remove last 2 numbers
Thank you,
I works.
Thanks
"Bob Phillips" wrote:
=rounddown(A1,2)
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Noemi" wrote in message
...
Hi
Which formula would we use to remove the last 2 numbers from a dollar
figure
as it is currently 4 decimals and we need it as 2 but do not want rounding
up.
We cannot change the format as the cell still represents as a 4 decimal.
eg
12.4555 is currntly in A1
12.45 is what we would like in B2
Thanks
Noemi
|