Feb 13, 2003 #1 99mel Programmer Joined Oct 18, 1999 Messages 379 Location GB I have a variable declared as currency. However if i set it to 2.50 for example it displayes 2.5 Is there a simple function to give 2 integers after the decimal point
I have a variable declared as currency. However if i set it to 2.50 for example it displayes 2.5 Is there a simple function to give 2 integers after the decimal point
Feb 13, 2003 #2 arst06d Programmer Joined Nov 29, 2002 Messages 324 try the format$ function eg format(amount,"0.00" Upvote 0 Downvote
Feb 13, 2003 #3 strongm MIS Joined May 24, 2001 Messages 20,264 Location GB Are you actually trying to display it as currency? i.e something like $2.50 or £2.50? If so, it might be advantageous to sue the format function with a slightly different format expression than that given above: format(amount, "currency" as this should adjust correctly for different regional settings. Upvote 0 Downvote
Are you actually trying to display it as currency? i.e something like $2.50 or £2.50? If so, it might be advantageous to sue the format function with a slightly different format expression than that given above: format(amount, "currency" as this should adjust correctly for different regional settings.