Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Bob, too
 
Posts: n/a
Default format data displayed on Excel data entry form

I am using Excels "built-in" data entry form to input elapsed time which is
formatted as [h]:mm:ss in the bound cell. Entries are captured correctly and
displayed correctly in the bound cell (e.g., 25:26:27).

However, after the leaving the record and returning to it, the data entry
form displays the times using AM/PM rather than 24 hour format, and for times
greater than 24 hours formats it as a full date in dd/mm/yyyy h:mm:ss AM/PM
format (e.g., 1/1/1900 1:26:27 AM).

Can I cause the data entry form to use my desired format? If so, how?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I export data from an Excel form into an external Excel d. vonda Excel Discussion (Misc queries) 1 April 21st 05 01:20 PM
Column format when merging Excel data to Word labels Red Excel Discussion (Misc queries) 1 April 6th 05 03:40 AM
create a data entry form template in Excel 2003? david.bottomley@haltoncollege Excel Discussion (Misc queries) 0 January 19th 05 10:59 AM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 06:55 PM
Data Entry Alert in User Form Kev Excel Discussion (Misc queries) 6 January 8th 05 04:01 PM


All times are GMT +1. The time now is 09:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"