Thread: zero
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mr bloby mr bloby is offline
external usenet poster
 
Posts: 5
Default zero

Hi can any one help with this one
i am trying to enter phone numbers in cells but when the number begins with
a zero it wont recognise it
if i fomat the cell and set it to text it will recognise the zero
is there anyway of doing this without formating and setting to text???
thanks in advance for any help