Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
excel2000 have entered dates on a spread sheet but dates have changed to
sequential numbers how can i retrieve or get the original dates back to the spread sheet |
#2
![]() |
|||
|
|||
![]()
Try formatting the cells as dates
format|cells|number tab|Date category Or if you see formulas (instead of what they evaluate to): tools|options|view|uncheck formulas. (this'll fix the display of the dates at the same time.) ten twenty wrote: excel2000 have entered dates on a spread sheet but dates have changed to sequential numbers how can i retrieve or get the original dates back to the spread sheet -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
have dates entered from a list of data into an excel template | Excel Discussion (Misc queries) | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
in excel why do numbers entered get divided by 100? | Excel Discussion (Misc queries) | |||
How do i increase the size of numbers in a text in Excel. | Excel Worksheet Functions |