Add a zero at the begining of a number without typing in each cel.

[Guest]

I need a formula that will add a zero to the begining of a column of numbers
that are already present. Not real familiar with if then statements. Unsure
if this would work.

 

[papou]

U§se a custom number format
ie:
your number = 4005
your wish = 04005
Format, Cell, Number, Custom
Format = "00000"

HTH
Cordially
Pascal

"Formula need for easier life" <Formula need for easier
(e-mail address removed)> a écrit dans le message de
news:[email protected]...

 

[Guest]

If the "numbers" are numbers and not text this won't work. First, add a
column that contains only 0 in each cell. Then format both columns to text.
Say they start in A1 and B1 then in C1 = A1&B1. Copy this formula to the end
of the data. If the formula will cause problems later, copy column C and
paste>special>values into whatever column you want. Hope this helps.

 

[IC]

"Formula need for easier life" <Formula need for easier
(e-mail address removed)> wrote in message

I need a formula that will add a zero to the begining of a column of numbers
that are already present. Not real familiar with if then statements. Unsure
if this would work.

Assuming data is in column A:
In B1 enter ="0"&A1. Copy down B as far as you need. This will create the
data in A with a preceeding 0.
If you want your data back in column A, select and copy the data in B then
Paste Special-Values.