remove last 2 numbers

N

Noemi

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
 
B

Bob Phillips

=rounddown(A1,2)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top