ExcelBanter - Decimal places

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Decimal places (https://www.excelbanter.com/excel-worksheet-functions/207827-decimal-places.html)

Tricia

Decimal places

I am trying to display less decimal places without the figure being rounded,
eg 29.37500 to display only 29.37. Can anyone help me with this please?

--
Tricia

Teethless mama

Decimal places

=TRUNC(A1,2)

"Tricia" wrote:

I am trying to display less decimal places without the figure being rounded,
eg 29.37500 to display only 29.37. Can anyone help me with this please?

--
Tricia

Ashish Mathur[_2_]

Decimal places

Hi,

you can also try this

ROUNDDOWN(A1,2)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Teethless mama" wrote in message
...
=TRUNC(A1,2)

"Tricia" wrote:

I am trying to display less decimal places without the figure being
rounded,
eg 29.37500 to display only 29.37. Can anyone help me with this please?

--
Tricia

All times are GMT +1. The time now is 06:58 PM.