ExcelBanter - special formatting adds extra zeroes

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - special formatting adds extra zeroes (https://www.excelbanter.com/excel-worksheet-functions/68809-special-formatting-adds-extra-zeroes.html)

nosnil14

special formatting adds extra zeroes

I have formatted columns for social security numbers and for telephone
numbers and the colums do not format the entries. I entered only the digits
and no dashes.

All times are GMT +1. The time now is 05:06 PM.