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!
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 -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Tangier" wrote: > 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! >
