View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default getting the zero digit to show in a cell e.g. 0456

Hi,

You can leave the zip code as numbers and then choose Format, Cells, Number
tab, Special, Zip Code or Zip Code + 4.

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"Diana in Wellington NZ" wrote:

When I number where the first digit is a e.g. post code/zip code 0358, I
can't get the zero to apprear unless I convert the cells to text format and
then re-enter the number.