Format from 870914143 to 8-709-14143
 

Hi,
I have a column that I would like to format like the sample below. I want to
keep the dashes between the numbers.
from 870914143 to 8-709-14143
Thank you so much

Format from 870914143 to 8-709-14143
 

Format cell as:

Custom==0-000-00000

HTH

"Mary" wrote:

Hi,
I have a column that I would like to format like the sample below. I want to
keep the dashes between the numbers.
from 870914143 to 8-709-14143
Thank you so much

Format from 870914143 to 8-709-14143
 

Hi,

try like below:

A B
1 870914143 =left(A1,1)&"-"&MID(A1,2,3)&"-"&RIGHT(A1,5)
2
3
4
5

then copy the formula in the cell B1 down to where ever you need it is
assumed that all the formats are the same for example if the data in the cell
A2 would be 546537365 the result come up like 5-465-37365 so if you don't
need the column B you can copy column B and pastespecial-value in the column
A and then delete column B.

Thanks,
--
Farhad Hodjat


"Mary" wrote:

Hi,
I have a column that I would like to format like the sample below. I want to
keep the dashes between the numbers.
from 870914143 to 8-709-14143
Thank you so much

Format from 870914143 to 8-709-14143
 

THANK YOU SO MUCH ALL

"Toppers" wrote:

Format cell as:

Custom==0-000-00000

HTH

"Mary" wrote:

Hi,
I have a column that I would like to format like the sample below. I want to
keep the dashes between the numbers.
from 870914143 to 8-709-14143
Thank you so much