Decimal places

[Tricia]

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?

 

[Teethless mama]

=TRUNC(A1,2)

 

[Ashish Mathur]

Hi,

you can also try this

ROUNDDOWN(A1,2)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com