Use the DollarFormat which will give you $0.00 format

Thus your numbers
#Dollarformat(199)# = $199.00
#Dollarformat(15.99)# = $15.99
#Dollarformat(5.99)# = $5.99

If using in a table just align that data cell to the right for
aligning the cents column.




----- Original Message -----
From: "LM" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 26, 2000 1:21 PM
Subject: Numberformat


I need help with the NumberFormat function. I need to format 3 dollar sign
values so that they are right aligned. The numbers vary in length for ex:
$199.99
         $15.99
          $5.99
Is there a way to specify the number of digits to display at all times?
Thanks for your help.



____________________________________________________________________
Get free email and a permanent address at http://www.netaddress.com/?N=1
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=sts&body=sts/cf_talk or send
a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.

------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Reply via email to