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


On Nov 20, 5:31 pm, Gord Dibben <gorddibbATshawDOTca wrote:
You stole my question<g

Gord Dibben MS Excel MVP



On Tue, 20 Nov 2007 10:47:50 -0800 (PST), wrote:
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

On Nov 20, 1:36 pm, Christielee
wrote:
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.- Hide quoted text -

- Show quoted text -