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) |