Thread
:
Date format error in Excel
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Bernie Deitrick
external usenet poster
Posts: 5,441
Date format error in Excel
Richy,
Format the cells as date, then in a blank cell, enter a 1, copy it, select all your date cells,
choose Edit / Pastespecial.... Check "Values" and "Multiply" and click OK.
HTH,
Bernie
MS Excel MVP
"Richy Rich" <Richy
wrote in message
...
I have a spreadsheet that has about 8000 records. It was working fine until I
started using some functions like (=trim) and (=clean). Now all my date
colums will not change from displaying the dates as numbers back to the
proper date format. The cell displays 38908 but the function field shows it
as 10/07/2006. I have formatted the cell every which way possible but it does
not change. Any suggestions?
Reply With Quote
Bernie Deitrick
View Public Profile
Find all posts by Bernie Deitrick