View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Displaying "0" Values

Tell us what you tried and in which way it didn't work.
--
David Biddulph

Ant wrote:
I am trying to type a series of numbers with "0"s. ex. 000058745.
When I do this excel kicks out all of the zeros. 58745. I need the
zeroes to be displayed in the cells. Also when I went to excel help,
it shows you how to do it and when I tried it, it did not work.
Please help!