Special Formatting of Number Field


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

Advertisements

J

JE McGimpsey

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

000-0000

in the textbox.
 
Ad

Advertisements

C

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top