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

Merge the last 4 digits of a number that contains a hyphen 2
Retrieving the last 4 numbers of a 9 digit field. 2
How to find set of numbers to sum nearest to a given total but not more? 4
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
Keeping code dynamic when adding columns to a list of records 2
Superscript character set of numbers 1

Top