View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 618
Default Postcodes starting with 0

If your number is a 5 digit code, for example, then you can format it as
00000, so that it will show leading zeroes.
--
David Biddulph

"Monza" wrote in message
s.com...
Hi Matt,

no a numeric format cannot begin with 0 unless that 0 preceeds a
period. Can I ask what you want to do with the data and why must it be
formatted as number?