remove last 2 numbers
 

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

remove last 2 numbers
 

=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

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