Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
converts numbers to dates
I need to save a file in a CSV format one of the columns contains years like
04-06 when I reopen the file later it has converted from 04-06 to 6-Apr I have fromated the cell to text but that dosen't seem to help it always opens up as 6-Apr. what do I need to do so that whenever I open a file that has 04-06 in the column it opens as 04-06. Any help would be appricated. Excel 2002 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
converts numbers to dates
Rename the file .txt
When importing, Excel will ask you what format -- Kind regards, Niek Otten "jason2444" wrote in message ... I need to save a file in a CSV format one of the columns contains years like 04-06 when I reopen the file later it has converted from 04-06 to 6-Apr I have fromated the cell to text but that dosen't seem to help it always opens up as 6-Apr. what do I need to do so that whenever I open a file that has 04-06 in the column it opens as 04-06. Any help would be appricated. Excel 2002 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
converts numbers to dates
If you rename the .csv file to .txt, you will have more control when bringing
the data in. -- Kevin Vaughn "jason2444" wrote: I need to save a file in a CSV format one of the columns contains years like 04-06 when I reopen the file later it has converted from 04-06 to 6-Apr I have fromated the cell to text but that dosen't seem to help it always opens up as 6-Apr. what do I need to do so that whenever I open a file that has 04-06 in the column it opens as 04-06. Any help would be appricated. Excel 2002 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reversing numbers to create dates | Excel Worksheet Functions | |||
numbers to dates | Excel Discussion (Misc queries) | |||
How do I generate random numbers using dates in excel? | Excel Worksheet Functions | |||
Match Last Occurrence of two numbers and Count to Previous Occurence | Excel Worksheet Functions | |||
Dates to numbers | Excel Worksheet Functions |