I need a simple excel formula

[Ange]

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

 

[Norman Jones]

Hi Ange,

In Excel try:

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

In VBA:

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