custom number format
 

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.
--
PMC

custom number format
 

"pm ctech" wrote:

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.
--
PMC

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)