Special Formatting of Number Field

[Guest]

I have a column that contains 5 digit numbers (12345) and I would like to
have this column formatted to add 2 leading zeros, then the first digit, a
dash, then the remaining 4 digits. For example, 12345 would be 001-2345. I
would to be able to format this column of numbers automatically, and not have
to do this for each cell.

 

[JE McGimpsey]

Select the column and choose Format/Cells/Number/Custom. Enter

000-0000

in the textbox.

 

[Chris Lavender]

Hi Weelhow
This seems to do it OK:

Format cells...
Custom category

enter in Type:

00#-####

OK
then copy and Paste Special Formats to the whole column (or use Format
painter)

Best rgds
Chris Lav