Newbie: VBA solution for making long numbers appear as text

[OM2]

I have a problem.
I open a CSV file that has long numbers in, like 98743987457849
If I make any changes and save as CSV, the number get saved as something like 3.8E+11

The way I can fix this is to format the cell as text, edit the cell but make no changes and press enter
Another solution is to create a column next to the column and put something like =A1&"" - but that isn't much use when I want to save

OK if it's just one or 2 cells - but I have many more and it becomes cumbersome to format cells, edit and press enter

How can I use VBA to solve?
How can I format an entire column as text format and then edit (and make no changes) and press enter?
Or maybe I can create a new column, format it as text, copy the values only to the new column and then delete the original column?

I'm a complete newbie to VBA and am not even sure how to create VBA and attach to a spreadsheet

ANY help/pointers would be great

Thanks


OM

[judgeh59]

Create a new column next to the numbers

put this formula in the new column and copy it down...do a copy/paste special to remove the formula and delete the old column.

If you want to automated it, turn on the macro recorder and follow the "Script" and turn off the recorder...

HTH

=TEXT(A1,"####################")

this will accomodate a 20 digit number....