View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default what is the formula

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.