| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
when loading csv file to Excel, cells get converted to date format
when loading csv file to Excel 2002, some numeric cells get converted to a
date format of type DD-MMM. RB |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
when loading csv file to Excel, cells get converted to date format
RB
This is Excel's auto-recognition 'feature'. So I suspect you have part numbers or similar with a dash in. To overcome this rename the file to either have a .txt extension, or none at all. This way, when using file<open..., you will get the text import wizard and be able to mark this column as text in the third step of the wizard -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "RB" wrote in message ... when loading csv file to Excel 2002, some numeric cells get converted to a date format of type DD-MMM. RB |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
when loading csv file to Excel, cells get converted to date fo
Hi Nick,
Thank you for your prompt response. One more question. I found <cr inside text cells. This causes a rwo to be broken into multiple ones. Is there a way for the wizard to "skip" those invalid <cr? RB "Nick Hodge" wrote: RB This is Excel's auto-recognition 'feature'. So I suspect you have part numbers or similar with a dash in. To overcome this rename the file to either have a .txt extension, or none at all. This way, when using file<open..., you will get the text import wizard and be able to mark this column as text in the third step of the wizard -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "RB" wrote in message ... when loading csv file to Excel 2002, some numeric cells get converted to a date format of type DD-MMM. RB |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
when loading csv file to Excel, cells get converted to date fo
RB
No, you would either need to find replace in the original data or the same in the destination -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "RB" wrote in message ... Hi Nick, Thank you for your prompt response. One more question. I found <cr inside text cells. This causes a rwo to be broken into multiple ones. Is there a way for the wizard to "skip" those invalid <cr? RB "Nick Hodge" wrote: RB This is Excel's auto-recognition 'feature'. So I suspect you have part numbers or similar with a dash in. To overcome this rename the file to either have a .txt extension, or none at all. This way, when using file<open..., you will get the text import wizard and be able to mark this column as text in the third step of the wizard -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "RB" wrote in message ... when loading csv file to Excel 2002, some numeric cells get converted to a date format of type DD-MMM. RB |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| EXCEL, Figures if they can be converted into tiff or EPS format | Charts and Charting in Excel | |||
| Can an Excel file be converted to a word doc? | Excel Discussion (Misc queries) | |||
| how to merge a date file into an excel format | Excel Discussion (Misc queries) | |||
| Can an Excel file be converted into Visio? | Excel Discussion (Misc queries) | |||
Hybrid Mode
