FORMAT() Function

Hey guys, I wanna put a decimal value in a text field. So i’m using the FORMAT function do to the task, but the thing is that I loose precision when the number ends with 0. Example: 50,00 gives me 50 when formatted. Is there anyway to keep these decimals? Thx a lot.

You can try using the following in the Format statement. <Precision,2:2>

quote:


Originally posted by m_leser
You can try using the following in the Format statement. <Precision,2:2>


… and you may replace with …[:)]