Special Formatting of Number Field

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Select the column and choose Format/Cells/Number/Custom. Enter

000-0000

in the textbox.
 
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
 
Back
Top