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.
|