Feb 13, 2003 #1 99mel Programmer Oct 18, 1999 379 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 Nov 29, 2002 324 try the format$ function eg format(amount,"0.00" Upvote 0 Downvote
Feb 13, 2003 #3 strongm MIS May 24, 2001 20,237 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.