Format Cell Question for the Pros

[caminochaos]

I have created a code (#+##.###) that would allow me to type:
2850.543

and it will display:
28+50.543

The problem that I am having is when I type in:
2800

It displays:
28+00.

It puts a "." at the end even though there is nothing after the decimal.

Please Help!

Thank you

 

[caminochaos]

Bump

 

[Cbrine]

If you drop the end of your format string, it seems to work.

#+##

Unless you want

2850.54 to display as 28+50.540, in which case we will need to dig deeper.

HTH
Cal

 

[caminochaos]

Yeah,

I tried that and it rounds it up to 28+51

I need the decimals to show up.

 

[grd]

Why are you trying to show a number in that format?

 

[caminochaos]

The format is road stationing. It is basically a line of reference to build a from.

28+00 means 2,800 feet (or meters).