How to change the value 12.3456 to 12.34 using string function

[arjakumar]

How to change the value 12.3456 to 12.34 using string function

[devarasu07]

Hi,

using string fxn? if so just use the left fxn =left(12.3456,5)

better way is the number fxn like below

=Num(12.3456,'##.00')

i.e update your field name instead of the hard coded value

[Anil_Babu_Samineni]

Num(Value,'##.00')

[jonathandienst]

Do you want to round the number (ie to 12.35) or round it down (to 12.34)?

Round up:  Ceil(12.3456, 0.01)

Round:  Round(12.3456, 0.01)

Round down:  Floor(12.3456, 0.01)

[arjakumar]

I also want to change 12.3456 to 12.35 when 3rd postion after decimal point is >=5.