View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
MikeR-Oz MikeR-Oz is offline
external usenet poster
 
Posts: 46
Default 0987 show in the cell - the zero drops off-ned all 4 digits

I type in 0987 in the top bar and yet I press enter the number in the row
cell shows 987 and the top bar no longer has the zero.

I looked at format and i have tried number , general, custom etc -- HOw to
get the zero and all four digits to show?

Thanks
Mike