Thank you for the answer Peo. You are right that the file is imported so
the problem is that after I change the values and convert them to
currency, they are no longer in their original format and cannot be
imported. Is their any way to convert the currency format - $00,00
(with a comma) right-aligned - to the original format - $00.00 (with a
point) left-align, which I believe is text?


--
DanielG
------------------------------------------------------------------------
DanielG's Profile: http://www.excelforum.com/member.php...o&userid=33056
View this thread: http://www.excelforum.com/showthread...hreadid=528715