I would like to find out why alphanumerics, e.g 14.02F100034 in separate
columns are not detected and hence "#N/A" was displayed. The whole worksheet
was copied and pasted from two separate worksheet and superimposed. I thought
that by formatting cells to GENERAL and pasting these data choosing PASTE
Specials with just Values Only would do the trick, and it failed. Please
advise what could be done to rectify the problems as the whole data contains
about more than 5000 rows of information.