Ashokraju
Luke M
I’m not sure that my contribution falls into the category of “some pretty fancy VB” but it does work :-)
I have uploaded a file to https://dl.dropbox.com/u/95000482/Retain_Text_Formats_1a.xls
The file contains 2 sheets, one containing only 5 records (based on the original...
Nazmul
As they say, don't knock it until you try it. My method sounds long winded, but only involves clicks of your left mouse button - typically 7 or 8 - and takes less than 10 seconds from start to finish. No typing of formulas, no finding macros in lists. On a column of 65536 records, Hui's...
@nazmul_muneer
You can convert from NUMBER to TEXT in the same column if you want to. It is a great way of removing numbers that come in to a spreadsheet in scientific notation as well, to avoid such lovely entries as 1E+06 etc.
Highlight the column [will also work on part of a column if you...