View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gilette Gilette is offline
external usenet poster
 
Posts: 1
Default formating tekst into numbers

Hi
I've importet a file and excel can't seem to understand that all the numbers
are, just that, numbers.
So every second collum reads the numbers as letters. (In the other colums it
read numbers as numbers)
I've tryed everything that is suggested on this page and in the help files,
but still...
Have done the substitute formula and even tho it takes away the space field
it do not read the numbers as numbers, but as letters.

Hopefully you understand my bad english, and any suggestions will be tryed
cause I really have to fix this problem.