Thread: ####
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
Posts: 9,221
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
---