what is the formula

C

Christielee

I am looking for the formula on how to add a 0 infront of my numbers. I can't
change it to text they need to stay numbers, i can't have it showing so a
format doens't work either.
I had the formula once before and now i can't remember it for the life of me.
 
P

Peo Sjoblom

Use formatting and custom, there is no formula that can append a leading
zero without changing it to text. So you are incorrect unless you meant add
a zero to the end


--


Regards,


Peo Sjoblom
 
K

krcowen

If it is not text, and it is not showing, what indication do you have
that it is actually there when you have what you want?

Ken
 
S

Spike9458

Custom formatting works as long as you are keeping the data in a
spreadsheet format. If you export to a text or csv format, it will
drop the "0". I've used =CONCATENATE(0,A1), where A1 is the cell you
need the zero in front of. It does convert the number to text, but the
0 stays put.

--Jim
 
S

Spike9458

I guess I should have read the entire post before making mine.

But, I have a twist on the question; If it is not text, and it is not
showing, then why do you need it?

--Jim
 
Top