Re: Stupid question: How to handle $ values?

[KChapman]

Try Val(Replace("$23.12", "$", "", "ALL"))

--Katrina

====================
Katrina Chapman
Consultant
Ameriquest Mortgage


                                                                                       
                                         
                    Reuben King                                                        
                                         
                    <reuben.king@        To:     [EMAIL PROTECTED]             
                                         
                    sbti.com>            cc:                                           
                                         
                                         Subject:     Stupid question: How to handle $ 
values?                                  
                    05/08/00                                                           
                                         
                    10:36 AM                                                           
                                         
                    Please                                                             
                                         
                    respond to                                                         
                                         
                    cf-talk                                                            
                                         
                                                                                       
                                         
                                                                                       
                                         



If I try to use val("$23.12"), it returns 0.  Other than doing a check
for the first character being a dollar sign, is there an easier way to
do this?

Thanks,
-RK
------------------------------------------------------------------------------

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.




------------------------------------------------------------------------------
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.