Text to Numbers NOT working
Hi,
I'm using Excel 2003. I have imported a table of data using cut and paste.
The numerical data reports back as TYPE = 2 i.e. text.
I have tried all the techniques outlined on this forum and the knowledge
base and none appear to work.
So I have use the copy/paste special with a copied number (0 or 1, Add or
Multiply)
I have used Data/Text to Columns etc. etc.
Any ideas?
regards,
bon
|