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.