I WORK WITH A HUGE SPEADSHEET THAT I HAVE TO MAKE FROM A 300,000 LINE TEXT
FILE. WILL BE GLAD WHEN OFFICE 2007 GETS OUT!! BUT MY QUESTION IS THAT SOME
OF MY COLUMNS COME THROUGH THE TEXT FILE AS "20000" AND I HAVE TO CONVERT
THEM TO 200.00 . IS THERE A WAY TO DO IT IN THE Same cell?? Now i have to
use a formula in a new column. thanks for any help.