| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CSV - text
I have "00012345" in a CSV file. when i open the CSV in excel, it comes up as
"12345". WITHOUT adding the apostrophe "'00012345" , how else can i get it to display the zeros in front of the numbers (because it's text, not numeric)? and the users don't want to go into format-cells each time. any global settings for this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| grab cell text from multi-tab workbook, show text in another workb | Excel Worksheet Functions | |||
| Sumif text is contained winthin a longer text string in a cell | Excel Worksheet Functions | |||
| Text does not display in "Text boxs" and when wrapping text in a c | Excel Discussion (Misc queries) | |||
| text (3750 char.)truncates with text wrap and row heigh adjusted? | Excel Discussion (Misc queries) | |||
| want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
Threaded Mode
