Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
open xml file in Excel
I'm using excel to open an XML file of address, but it truncates the leading
zero if a zip begins with one. I don't have the option of modifying the source file and putting in an apostrophe. Is there a way around this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
open xml file in Excel
If the zip is in its own column, A for example, you might use a helper
column. For a zip such as 1234 which should be 01234 you could use a formula like =IF(LEN(A1)=4,"0"&A1,A1). For a zip such as 1234-5678 You could use =IF(LEN(A1)=9,"0"&A1,A1) The results of both formulas will be text. If you're satisfied with the results, you can delete column A and use the helper column as the zip code. Tyro "Joe" wrote in message ... I'm using excel to open an XML file of address, but it truncates the leading zero if a zip begins with one. I don't have the option of modifying the source file and putting in an apostrophe. Is there a way around this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
Excel hangs when trying to open a file but it's ok if i open exce. | Excel Discussion (Misc queries) | |||
In Excel - Use Windows Explorer instead of File Open to open file | Excel Discussion (Misc queries) | |||
Open email windows can't open, excel shreadsheet file .xls ? | Excel Discussion (Misc queries) | |||
How do I stop Excel from closing the open file each time I open a. | Setting up and Configuration of Excel |