Custom Format

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

I could indeed lol thankyou very much