| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers change when saving as a csv fle
I have an excel spreadsheet with a date field. The date currently shows
1/7/2008. I need all of the dates to show 2009, so I find and replace all 2008s with 2009. I then save the file as csv. When I reopen the file everything seems fine until I change the date format to show Jan-09 and save it again as csv. When the file is reopened again not only does the format change (which isn't my concern) but the year goes back to 2008!!! I've tried saving to text and then opening in excel but this doesn't make a difference. Any suggestions or explanations as to why 2009 goes back to 2008? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formatting is change after saving .csv file | Excel Discussion (Misc queries) | |||
| Saving current worksheet on cell value change | New Users to Excel | |||
| Saving templates with sequential numbers | Excel Discussion (Misc queries) | |||
| saving dates\invoice numbers | Excel Discussion (Misc queries) | |||
| saving change in toolbar | Excel Worksheet Functions | |||
Threaded Mode
