Hi Ange,

In Excel try:

=TEXT(TRUNC(A1),"0")

In VBA:

Dim sStr as String
sStr = CStr(Fix(85.52))

---
Regards,
Norman



"Ange" wrote in message
om...
Hello All.

I need a formula that will get rid of the decimals to the right side
of my period. The cells have to be in TEXT format.

85.10 must end up like 85

Please help,

regards