Entering multiple literal values in a spreadsheet

[Tangier]

Hi,

I have to enter 6 digit numbers in a CSV file. When I re-open the CSV
file, it will delete the leading 0s in the number. So 00001 looks like
1.

If I enter =0001 in a cell, then the cell displays the literal value.
This is good. However, how do I do this for 400 different cells in a
row.

THanx!

 

[Shane Devenshire]

Hi,

If all you want to see when you open the file in Excel is 000001 or then you
can apply the custom format 000000 to the cells - this will pack leading
zeros in the display.

If you want the numbers to actually contain the leading 0's then either
format the range to Text before entering the data or in another column enter
a formula such as

=RIGHT("00000"&A1,6)

and copy it down