without knowing the layout, it's pretty hard to come up with some code.

what i have done is copy a blank cell, pastespecial over the number stored
as text and select add and then ok.

but if there is some consistent layout, just post back.

--

Gary
Excel 2003


"lwm" wrote in message
...
Is there an efficient vba module to convdert any numbers stored as text in
a
file.

This is a problem with many accounting systems that extract data to a
"Excel
File".


Using vllokups ad such creates problems when one file is in stored as text
and the other is stored as a number.


Thanks