| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get 00 or 01 from XML to Excel it displays as 0 or 1?
When importing data from XML into an excel speadsheet a lot of the data is in
the format 00 or 01 etc. When imported it displays as 00, 01 etc but when the cell is selected it only contains 0 or 1. It drops the lead 0. Ant suggestions please! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I get 00 or 01 from XML to Excel it displays as 0 or 1?
"Ross" wrote in message
... When importing data from XML into an excel speadsheet a lot of the data is in the format 00 or 01 etc. When imported it displays as 00, 01 etc but when the cell is selected it only contains 0 or 1. It drops the lead 0. Ant suggestions please! Format as 00 -- David Biddulph |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 5 and Excel 2000 question. | Excel Discussion (Misc queries) | |||
| Pivot table displays data differently, Excel 2003 | Excel Worksheet Functions | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| \ displays as back slash in Excel and power point | Excel Discussion (Misc queries) | |||
| Value Errors with EXCEL XP not showing up in EXCEL 2000 | Links and Linking in Excel | |||
Hybrid Mode
