Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
leading zero truncate - how to prevent ?
When importing a .csv file where the data is encapulated (each item of data
is enclosed in double quotes) excel strips off the leading zeros. Is there any way of preventing this from happening ? The issue particularly nasty in that it removes preceeding zeros from a zip-code, then the US postal service will not deliver. Any ideas ? |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
leading zero truncate - how to prevent ?
Hi Gary,
I would suggest fixing 5-digit zip codes with a macro, see http://www.mvps.org/dmcritchie/excel/join.htm#fixUSzip5 You can try changing the .csv extension to .txt and then during the Text Import Wizard indicate that the column is text. It probably won't work though. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Gary N" <Gary wrote in message ... When importing a .csv file where the data is encapulated (each item of data is enclosed in double quotes) excel strips off the leading zeros. Is there any way of preventing this from happening ? The issue particularly nasty in that it removes preceeding zeros from a zip-code, then the US postal service will not deliver. Any ideas ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Leading Zeros | Excel Discussion (Misc queries) | |||
How to prevent Excel from deleting leading zeros? | Excel Discussion (Misc queries) | |||
Remove leading space | Excel Worksheet Functions | |||
Concatenation with leading zeros | Excel Worksheet Functions | |||
I WANT to truncate my leading zeros | Excel Discussion (Misc queries) |