View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default Problems with entering cell number

Hi

Excel does not retain leading zeros with numbers.
You will need to enter it as text.
Either, preformat the cells as Text, or, insert a single quote in front of
the number as you enter it
'012345

--
Regards
Roger Govier



"Magda" wrote in message
...
When entering a cell number into one of the cells in xcell it throws the
zero
away. What do I do to fix this?