Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number format to date
When I save a spreadsheet to .csv and it has account numbers "01-15-2000"
Excel automatically saves them as dates. I can Lock the cell, format it as text, etc. and it has no effect. I need to use .csv to upload data to my ERP application. If I use an " ' " in front of the data the upload doesn't read it correctly as just the account code. I need to use a "shout out" --- HELP!! -- Bill |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number format to date
Rename the .csv file to .txt
Then open excel, use File|open to open that .txt file. You can follow the import text wizard to tell excel that this field should be treated as text. Maxfli wrote: When I save a spreadsheet to .csv and it has account numbers "01-15-2000" Excel automatically saves them as dates. I can Lock the cell, format it as text, etc. and it has no effect. I need to use .csv to upload data to my ERP application. If I use an " ' " in front of the data the upload doesn't read it correctly as just the account code. I need to use a "shout out" --- HELP!! -- Bill -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number format to date
Ignore that previous response.
That was a way to open that .csv file in excel. But I bet if you check your .csv file by opening it in NotePad--or any text editor (don't use Excel), then your field will be ok. Maxfli wrote: When I save a spreadsheet to .csv and it has account numbers "01-15-2000" Excel automatically saves them as dates. I can Lock the cell, format it as text, etc. and it has no effect. I need to use .csv to upload data to my ERP application. If I use an " ' " in front of the data the upload doesn't read it correctly as just the account code. I need to use a "shout out" --- HELP!! -- Bill -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number format to date
Excel opens them as dates not saving them. Test that by format as text, put
in 01-15-2000 as text, save as *.CSV and open the file in notepad or any text editor. If you open them in Excel it converts them, to dates, so if you need to open them in Excel you can import them instead as text using the text import wizard -- Regards, Peo Sjoblom "Maxfli" wrote in message ... When I save a spreadsheet to .csv and it has account numbers "01-15-2000" Excel automatically saves them as dates. I can Lock the cell, format it as text, etc. and it has no effect. I need to use .csv to upload data to my ERP application. If I use an " ' " in front of the data the upload doesn't read it correctly as just the account code. I need to use a "shout out" --- HELP!! -- Bill |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number format to date
Dave and Peo -- Bless You!
Thanks, Bill "Peo Sjoblom" wrote: Excel opens them as dates not saving them. Test that by format as text, put in 01-15-2000 as text, save as *.CSV and open the file in notepad or any text editor. If you open them in Excel it converts them, to dates, so if you need to open them in Excel you can import them instead as text using the text import wizard -- Regards, Peo Sjoblom "Maxfli" wrote in message ... When I save a spreadsheet to .csv and it has account numbers "01-15-2000" Excel automatically saves them as dates. I can Lock the cell, format it as text, etc. and it has no effect. I need to use .csv to upload data to my ERP application. If I use an " ' " in front of the data the upload doesn't read it correctly as just the account code. I need to use a "shout out" --- HELP!! -- Bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically format number as date | Excel Discussion (Misc queries) | |||
How do you format a number into a date? | Excel Discussion (Misc queries) | |||
convert number to date format | Excel Discussion (Misc queries) | |||
* next to date format in Formatcells Number tab | Excel Discussion (Misc queries) | |||
Excel: I enter date and format for date, but shows as number | Excel Discussion (Misc queries) |