Forcing two decimal places on integers

[Macfreq]

Hopefully this is a simple answer. I have a calculation that returns a number, but I need that number to have two decimal places, even when the result is an integer.

Is there a function that can return a text string for the number that will always have two decimals after the decimal point? The result is going into QuickBooks as an amount and it is required to have two decimal places (10.00 not 10)

Thanks.

[LaRetta]

A post by Comment ...

01/10/05 08:25 AM - Post#140962

In response to QuinTech

Int ( Round ( InputNumber , 2 ) )

& "." &

Right ( "00" & Round ( Abs ( InputNumber ) * 100 , 0 ) , 2 )

[LaRetta]

Ooops, untested ... change those commas to semi-colons.

[Macfreq]

Thanks, that will work fine.