Thread: number format
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default number format

Two ways:

1. type a single quote (apostrophe) before the set of digits
2. if the set of digits is fixed in length, say four, then format the cell
as custom
0000
--
Gary''s Student - gsnu200761


"cheri" wrote:

i have a column set up in number format, in a lot of places the first number
is 0, (zero). after i enter my info it always drops the 0. How do I correct
this? I need the 0 to be there