| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date format
Please could someone assist.
I have some data submitted to me, which on the screen is displayed as 1926:04:12 (which is the year:month:date), though excel is holding the data as a time field, in the background which is 20/03/1900 06:04:12. How do i capture the true data, I have tried various format changes, though excel believes its the time i am changing not the values which i am seeing on the screen. any help would be appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: I enter date and format for date, but shows as number | Excel Discussion (Misc queries) | |||
| Can I change a date with no format (20051111) to date format? | New Users to Excel | |||
| day/month/year in incorrect format for date format | Excel Worksheet Functions | |||
| How can I convert a date format to an ISO week format (in EXCEL)? | Excel Discussion (Misc queries) | |||
| Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) | |||
Threaded Mode
