[RESOLVED] Code Help

[gavio]

Debug.Print Format(yourCurrencyVariable, "###,###.00")

[MartinLiss]

Another way would be

curtotal = FormatNumber((((curftotal + curstotal + curbtotal) * sngtax) + (curftotal + curstotal + curbtotal)),2)

where 2 is the number of decimal places you want.

BTW it's better to use [highlight=vb][/highlight] tags when posting code. Then to get around the problem with copy/paste of code formatted that way you can use the app you can download from the Copy/Paste VB Code link in my signature.

[BrainA]

[QUOTE=MartinLiss]Another way would be

curtotal = FormatNumber((((curftotal + curstotal + curbtotal) * sngtax) + (curftotal + curstotal + curbtotal)),2)

where 2 is the number of decimal places you want.
QUOTE]


thanks thats perfect

Thank you all

[MartinLiss]

Now that we've helped you, you can help us by pulling down the Thread Tools menu and clicking the Mark Thread Resolved button which will let everyone know that you have your answer.