in a formula, how do I make a number always be two decimal places?

not in a script. in a netsuite formula, so SQL

I think

ROUND(NUM, 2)

does the trick

Yeah, that doesnt seem to work of its already an even number

Use TO_CHAR(yournumber, '$99,999.99')

That works. I was trying to keep it as a number, but cant figure it out

As far as numbers are concerned. 1.10 and 1.1 are the same thing

well, its a calculated price. I wanted to have it show formatted to 2 decimal places and also be able to use in calculations without converting back to number.

you have the field formatted as a currency, right?

no..... But that works. I was thinking that wouldnt work since the field value can be blank