convert Question

[Rahul Mishra]

sir how can i convert 28838210 into
2.883-821.0
format by excel formula

 

[Deepak]

Is this ........

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

 

[NARAYANK991]

Hi Rahul ,

Another posibility :

=REPLACE(REPLACE(REPLACE(A1,2,,"."),6,,"-"),10,,".")

where A1 has the value 28838210.

Narayan

 

[Syedali]

Another one
=SUBSTITUTE(SUBSTITUTE(A1,".",""),"-","")

 

[Deepak]

Another one
=SUBSTITUTE(SUBSTITUTE(A1,".",""),"-","")

You might understood wrong.... as are doing reverse.

 

[Syedali]

You might understood wrong.... as are doing reverse.

Sorry . I just overlooked. Once again sorry

 

[Syedali]

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,2,"2.",1),3,"3-"),1,"1.")

A1=28838210

 

[oldchippy]

@Syedali

Your formula works perfectly for the example given, but if there are any more numbers you have problems - try it.
28838210
28838211
28838212
28838213
28838214
28838215

 

[Khalid NGO]

Hi Rahul,

You've got formula solutions, here is the custom format:
#"."###"-"###,".0"
%%\%\%

Length of string must be same.

Regards,