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