Thread: number input
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
SteveW SteveW is offline
external usenet poster
 
Posts: 427
Default number input

If you want the numbers to be treated as numbers not text,
format the cell first to have custom format of 00000


On Thu, 03 Aug 2006 17:10:02 +0100, dennisp
wrote:

Wht is it that Excel does not accept a zero as the first number of a 5
digit
zip code? How do you get Excel to accept it?




--
Steve (3)