Forums
 This topic is locked 
             Need help with data formating and currency
 Posted 28 Jul 2002  04:51:29 
  1 
     has   voted 
  28 Jul 2002  04:51:29 Matt Flood posted: 
 ok her is the deal I am getting a file with tax info on it. The only problem i am having is all the data doesn't have decimas where there should be. Example in the file it would look like 2000 but I need it took look like 20.00  I am not sure how to get this decimal point in there. When I import the data into access as currency it adds a decimal point and two zeros. It makes it look like 2000.00. Which there is a big difference between 20 bucks and 2000. I have also set in the recordset  the binding type and no help. I need to fix this. Thanks for the help.