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