View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gmonny Gmonny is offline
external usenet poster
 
Posts: 2
Default Display leading zeros in numeric value without converting to text

I'm trying to use a numeric value with a leading zero, but the format keeps
dropping the leading zero. I've tried custom formatting, but it also drops
the lead zero. The only way to display the leading zero is to format the
value to text, but then it places the text tag in the cell, which I don't
want. Is there a way to format a cell to allow leading zeros without
converting or formatting the value as text?