Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I remove Row Numbers? Or have the Row Numbers start on the Ro | Excel Discussion (Misc queries) | |||
Numbers won't sort correctly. | Excel Discussion (Misc queries) | |||
Numbers won't sort correctly. | Excel Discussion (Misc queries) | |||
Validating random numbers | Excel Worksheet Functions | |||
GET NON-ZERO RESULTS USING STDEV FOR CERTAIN NUMBERS | Excel Worksheet Functions |