Split a number

[Kazdima]

Hello,

How to convert this number [TABLE="width: 102"]
<tbody>[TR]
[TD="width: 102"]1028518000350
Into:
[TABLE="width: 122"]
<tbody>[TR]
[TD="class: xl64, width: 122"]10-285-1-800-0350[/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[/TR]
</tbody>[/TABLE]

Thank you.

 

[philwojo]

You could set a Custom format for the cell to be "##-###-#-###-####"

 

[Rick Rothstein]

Hello,

How to convert this number [TABLE="width: 102"]
<tbody>[TR]
[TD="width: 102"]1028518000350
Into:
[TABLE="width: 122"]
<tbody>[TR]
[TD="class: xl64, width: 122"]10-285-1-800-0350[/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[/TR]
</tbody>[/TABLE]

If you want a physical value in a different cell, you could use ths formula...

=TEXT(A1,"00-000-0-000-0000")