| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Autoformat dates and times
Hi,
I have a workbook with two columns. In the formula bar of one of the cells i have 2005040101700 (YearMonthDateHoursMinutes), but what shows in the cell is 2.00504E+11 When I try to format the cell as yyyymmddhhmm I get ########### and when I put the cursor over the cell with ############### it says that negative dates and times are shown this way. How can I make this work? Thanks. Allison |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I calculate duration between two dates and times in excel? | Excel Discussion (Misc queries) | |||
| dates and times | Excel Discussion (Misc queries) | |||
| Dates and times with PST,PDT | Excel Worksheet Functions | |||
| merge dates and times into one column? | Excel Discussion (Misc queries) | |||
| Formula to calculate elapsed time between certain dates and times | Excel Discussion (Misc queries) | |||
Threaded Mode
