Forums

ASP

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.

Reply to this topic