I need a simple excel formula
 

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

I need a simple excel formula
 

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