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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding a dash
Jim,
Select those cells and then Format|Cells - Custom enter a custom format of 0-00 Mike "Jim" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding a dash
This is perfect - I have another question if you have a moment.
When I pulled this data the dates came over looking like this: 1090325 This represents March 25, 2009. All of the dates have the 1 in front of them. How do I eliminate the "1" and show a proper date? Thanks "Mike H" wrote: Jim, Select those cells and then Format|Cells - Custom enter a custom format of 0-00 Mike "Jim" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding a dash
Use Text to Column Option under Data Menu
Hardeep kanwar "Jim" wrote: This is perfect - I have another question if you have a moment. When I pulled this data the dates came over looking like this: 1090325 This represents March 25, 2009. All of the dates have the 1 in front of them. How do I eliminate the "1" and show a proper date? Thanks "Mike H" wrote: Jim, Select those cells and then Format|Cells - Custom enter a custom format of 0-00 Mike "Jim" wrote: 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 |
Reply |
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 |