| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding a dash
Hello,
I have a column of numbers that I pulled from a database. The numbers look like this: 159611 2395301 12451111 69996709 I need to add a dash in order to seperate teh last two digits. What is hte best way to perform this task? The numbers should look like this: 1596-11 23953-01 124511-11 699967-09 Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding a dash to phone numbers | Excel Discussion (Misc queries) | |||
| Unwanted dash | Excel Worksheet Functions | |||
| dash | Excel Worksheet Functions | |||
| adding a dash | Excel Discussion (Misc queries) | |||
| understanding dash dash in a excel formula | Excel Worksheet Functions | |||
Threaded Mode
