Custom Format

[jc0r]

Hi, i was wondering if someone could help me with custom formats.

I am trying to display decimal numbers slightly differently to what the actual true value of the cell is.

Example.

If the cell reads 0.41, i would like it to show 1.41. If the cell reads 3.4 i would like it to show up as 4.4 etc.

I have tried just adding a custom format of 1.0 which works for all cells under 1.0 i.e 0.41 however, over that and i get the wrong result. For 11.0 it would read 111.0 when i actually want 12.0 to be shown.

Sounds a little wierd i know but can anyone please help me out on this one.

Many thanks

[oldchippy]

Can't you just use an helper column =A1+1?

[jc0r]

I could indeed lol thankyou very much

[oldchippy]

Glad to help, I sounded a lot more complicated that!