Converting Number to currency

[paul123456]

My problem is that when i import from an excel sheet the number in the column in the sheet will read as numbers and not currency..for exm: a number of 15000 in currency will read to 15000.00...The part that i can't get around is i just what it to read as 150.00...when i imported into the database and the field was converted to currency it added .00 to all records..which is wrong..i just needs to place the decimal two places to the left of the number...is there a way to do this automated?

Thanks, PAUL

 

[willir]

Paul
You should be able to run an update SQL query to divide your number by 100.

Richard

 

[paul123456]

Oh that sounds like that will work...since i don't know how to do that a sql query i will do it using excel...thnk for the info!

Thanks, PAUL