ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   micosoft excel dates entered but changed to sequencial numbers ho. (https://www.excelbanter.com/excel-worksheet-functions/7735-micosoft-excel-dates-entered-but-changed-sequencial-numbers-ho.html)

ten twenty

micosoft excel dates entered but changed to sequencial numbers ho.
 
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

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


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

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