Currency accounting question

M

Mitch

Hi There,
I have exported data from Access 2002 to excel 2002 so i can change it and
then import it into MYOB accounting.
The problem is Access spits out the data like this (eg) 3909 when it should
be $39.09
No matter what i format i try to use i end up with $3,909 or $3,909.00. Is
there a simple formula i can use to change all my cells? I have about 500 to
change and manually it would be a real pain!!

Any help is greatly appreciated.

Cheers and Thanks

Mitch
 
C

Chip Pearson

Mitch,

You can divide all the values by 100 by entering 100 in some empty
cell, then copy that cell, select the values to be divided, go to
the Edit menu choose Paste Special, and choose the Divide
operation.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com [email protected]
 
Top