what is the formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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