Adding hyphen within a set of numbers

J

Jacqueline

Hi all,

I usually face set of numbers that consists of 9 numbers. E.g
123456789, 987654321.

I'm figuring how to add a hyphen between the 8th and 9th character
which will enable the numbers to look something like 12345678-9,
98765432-1. The set of numbers of cos varies day to day.

Pls help. Appreciate if anyone could enlighten me. =))
 
R

Rick Rothstein

Do you need to physically change the values to include the hyphen or would
simply leaving the number as is and displaying it with the hyphen be okay
(that is, the cell value would still be 123456789, but it would display as
12345678-9)? If this would be alright, then just Custom Format
(Format/Cells/Custom from the menu bar) using 00000000-0 as the custom
format Type pattern.
 

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

Similar Threads

Retrieving the last 4 numbers of a 9 digit field. 2
All variations of a set of numbers and letters 3
Adding rows using a list of numbers 2
Frequency of numbers in a range 6
Help Merging Identical rows within a large set of data 1
Where is the "Chart Menu" for adding a trendline to a set of #s? 1
Keeping code dynamic when adding columns to a list of records 2
command button that puts specific numbers in a range of cells 2

Top