custom number format

[pm ctech]

I want to change an eight digit number into the following format:
11111111
x.xxx-xxx.x
should look like 1.111-111.1

I need to create this as a custom number format because I use it all the time.

 

[Kamal]

I want to change an eight digit number into the following format:
11111111
x.xxx-xxx.x
should look like 1.111-111.1

I need to create this as a custom number format because I use it all the time.

use the following formula

Assuming your 8 digit number is in cell A1,

=LEFT(A1,1)&"."&MID(A1,2,3)&"-"&MID(A1,5,3)&"."&RIGHT(A1,1)