View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BON BON is offline
external usenet poster
 
Posts: 1
Default 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