| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date format error in Excel
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 Date Format Problem | Excel Discussion (Misc queries) | |||
| Excel date format issue | Excel Discussion (Misc queries) | |||
| How to format date cells, Excel template Project scorecard matrix | Excel Worksheet Functions | |||
| Excel: I enter date and format for date, but shows as number | Excel Discussion (Misc queries) | |||
| Excel Query Wizard Date Format | Excel Discussion (Misc queries) | |||
Threaded Mode
