| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Help please, excel format conversion
I have thousands of numbers in a colum in the following format 1/234567/890 and need to convert them into this format 123-456789-0. Could someone please advise on a formula for this conversion. I will be eternally grateful
love steve |
|
#2
|
|||
|
|||
|
In a helper cell, put a formula like:
=TEXT(--SUBSTITUTE(A1,"/",""),"000-000000-0") and drag down the range. You can copy|paste special|values and delete the original range if you want. stevenpwhite wrote: I have thousands of numbers in a colum in the following format 1/234567/890 and need to convert them into this format 123-456789-0. Could someone please advise on a formula for this conversion. I will be eternally grateful love steve -- stevenpwhite -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003, It wont print in landscape format | Excel Discussion (Misc queries) | |||
| Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
| EXCEL FORMAT PROBLEM WHEN SENDING EXCEL SHEET AS MESSAGE BODY IN . | Excel Discussion (Misc queries) | |||
| How do I convert Excel 2003 to Excel 98 format? | New Users to Excel | |||
| In Excel, how can you format for 4 digit years (MM/DD/YYYY)? | Excel Discussion (Misc queries) | |||
Linear Mode
