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

  • Thread starter Formula need for easier life
  • Start date
F

Formula need for easier life

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.
 
P

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
[email protected]> a écrit dans le message de
news:[email protected]...
 
C

cwilson

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.
 
I

IC

"Formula need for easier life" <Formula need for easier
[email protected]> 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.
Click to expand...

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.
 
Top