Thread: How can I keep zeros in the beginning of a number in excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default How can I keep zeros in the beginning of a number in excel
To enter it as text, either precede the entry with an apostrophe or preformat
the col as Text. If you want it retained as numbers but to display the
leading zeros in the cells, preformat the col as custom, type: 0000 (for
example)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Starprincess" wrote:
Everytime I type in a number that starts with zeros in an excel cell - excel
automatically drops the zeros from the number how can I format the cell to
keep the zero?
Reply With QuoteReply With Quote