ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   format data displayed on Excel data entry form (https://www.excelbanter.com/setting-up-configuration-excel/26941-format-data-displayed-excel-data-entry-form.html)

Bob, too

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?


All times are GMT +1. The time now is 02:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com