Formating cell

[Guest]

I have a number say 100.00, I would like to make it into 1+00
so for 236.50 the cell would produce 2+36.50 and for 24.36 will make it 0+24.36
Can this be done in Excel?
Thanks for the help!
C. Fillmore

 

[Domenic]

Hi,

Try custom formatting the cells as follows:

0+00.00

Hope this helps!

 

[Frank Kabel]

Hi
try the custom format
0"+"00.00

 

[nezinu]

Do you need these strange numbersDD (0+24.36) to be recognised lik
numbers??? If not, then use text functions. For example: You can forma
number like text, choose: Format>Cells>Number Tab>Text. Then split thi
text with mid() function and then merge with concatenate()