Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Exporting numbers into Excel
I am exporting a tab delimited file into excel. The question is and not just
for this project but in general. I have a figure 05 and it always shows up as 5. How can I get it to display the zero. Excel strips it , even in the ..xls. format. |
#2
|
|||
|
|||
When you import the file, you can specify that that field be treated as text.
Or after you import it as a numeric value, you can format that column with a custom format of: 00 shedevel143 wrote: I am exporting a tab delimited file into excel. The question is and not just for this project but in general. I have a figure 05 and it always shows up as 5. How can I get it to display the zero. Excel strips it , even in the .xls. format. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change column labels from numbers to letters in Excel? | Excel Discussion (Misc queries) | |||
How can I stop Excel from displaying rounded numbers? Credit car. | Excel Discussion (Misc queries) | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
How do I make Excel stop rounding off my numbers that are 16 digi. | Excel Discussion (Misc queries) | |||
in excel why do numbers entered get divided by 100? | Excel Discussion (Misc queries) |