Thread: ####
View Single Post
  #4  
Old January 16th, 2008, 03:26 PM posted to microsoft.public.excel.newusers
Max
external usenet poster
 
Posts: 8,574
Default ####

one guess on your 2nd question
..Also, how do I add ZERO's? When I add a ZERO, it is not included.

Type a preceding apostrophe if you want leading zeros
eg: enter it as '090
The apostrophe won't display in the cell, but it'll become a text number
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---