Change the number of charaters in a cell by adding a zero

G

Guest

I need to change the number of charaters in a cell by adding a zero to the beginning. Example 12345678 to 012345678. Tried changing formats, number to text, and custom with nine zeros.

Thanks
 
G

Guest

Peter,
Both changing the number to text, and the nine 0 custom format should work.

If you changed the number format to text after you had entered the number, then the preceding zero was already dropped before the format change. You need to change the number format to text before entering the number.

If you change the number format to the nine zero custom after you had already changed to cell to text, the number is not converted back to a value until you do somthing to it, like click in the formula bar and hit enter. Again you need to change the format before entering the number.

Good Luck,
Mark Graesser
(e-mail address removed)


----- peter wrote: -----

I need to change the number of charaters in a cell by adding a zero to the beginning. Example 12345678 to 012345678. Tried changing formats, number to text, and custom with nine zeros.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is there away to add a zero to the beginning of number string? 5
Deleting Rows on the basis of cell comment 4
Why is Formula not calculating? 4
display zero values at the beginning of a number. 2
limit no of characters in cell 3
Splitting data in a cell 1
Formatting a cell - remove a dash 5
Change the number of charaters in a cell by adding a zero to the beginning 2

Top