Removing integer, to leave decimal (but showing as a whole number)

[Andrew_D]

Hi,

I had a look for a similar query but couldn't find much (just questions asking how to leave the decimal, but retaining the point).

I am trying to lose the integer from a number, for example to show 4.5 as 5 (rather than 0.5), or 6.3 as 3 etc.

Any help with this would be greatly appreciated.

Thanks,
AD

 

[Joe4]

Welcome to the Board!

Is it always just one decimal place?

If so, this formula should work: =(A1-INT(A1))*10
(where A1 is the cell where the number resides)

 

[Andrew_D]

Thanks!

I knew it would be something simple! Bit of a head slap moment when I saw it was just a *10 on the end as I found the =(A1-INT(A1)) formula in another thread

Thanks also for the welcome, I can't believe I've not found this site before!

AD