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


"Christielee" wrote in message
...
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.

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.

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.

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 -

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


On Nov 20, 6:18 pm, Spike9458 wrote:
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 -- Hide quoted text -

- Show quoted text -

That is what we all want to know

--


Regards,


Peo Sjoblom



"Spike9458" wrote in message
...
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


On Nov 20, 6:18 pm, Spike9458 wrote:
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 -- Hide quoted text -

- Show quoted text -