Display 3 zeros infront of numbers

Topic

New Reply

Hi all,

I have a CSV file that i import the data onto a payroll system. Before I import the data on one of the columns I put three zeros in front of numbers and I use the following formula =”000″ & B on a different cell i.e. f2, I then copy paste values on cell b2. this displays the zeros before the numbers on Column./ cell B2. I than save the file it gives me a few warning and click yes to those, etc. and usually when I open the file the zeros are there, but this time they are all gone.

Does anyone know what the problem is?

Cheers

Reply | Quote

Replies

Me, I’d check how your cell(s) is/are formatted…

BATcher

Plethora means a lot to me.

Reply | Quote

How should the cells be?

Reply | Quote

How are you opening the file to check? In Excel or Notepad (or some other text editor)?

Reply | Quote

Hi all,

I have a CSV file that i import the data onto a payroll system. Before I import the data on one of the columns I put three zeros in front of numbers and I use the following formula =”000″ & B on a different cell i.e. f2, I then copy paste values on cell b2. this displays the zeros before the numbers on Column./ cell B2. I than save the file it gives me a few warning and click yes to those, etc. and usually when I open the file the zeros are there, but this time they are all gone.

Does anyone know what the problem is?

Cheers

I believe that Excel have converted text to number automatically.
Why don’t you try custom formatting your cell, it is much more robust

Reply | Quote