Try the RJUSTIFY function. It aligns a string to the right and pads 
the rest with spaces.

Example:  RJustify("3.99", 10) Looks like:

      3.99


On 26 Jun 2000, at 11:21, LM wrote:

> 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
> send a message to [EMAIL PROTECTED] with 'unsubscribe'
> in the body.



--
Al Everett
Web Applications Developer
G.Triad
tel: 973.428.9600
fax: 973.428.1112
[EMAIL PROTECTED]
http://www.gtriad.com/
------------------------------------------------------------------------------
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