Formatting

[Guest]

Hi
How can i have codes in this form 00.00.0000.00, & i wanted to sum to the values below like next code, 00.00.0000(+1).00 I'm tired to format but always sum in the last 2 digits 00.00.0000.00(+1), what can i do
Someone can help me
Thanks

 

[Dave Peterson]

How did you put 00.00.0000.00 in the cell?

Did you type 0 and then give it a custom format?

If yes, try changing your custom format to:
00\.00\.\0000.00

Then add 1, but make sure that the resulting cell also has this custom format.

This is really a funny formatted number with 2 decimal places now.