Thread: csv file import
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
SteveW SteveW is offline
external usenet poster
 
Posts: 427
Default csv file import

If it's a comma seperated file - it should load correctly.

what format is the data ?

and as mentioned - is it plain text

Steve


On Fri, 14 Jul 2006 17:41:02 +0100, d_kight
wrote:

I have tried and succeeded in importing a .csv file into excel. This
file has
numerical values. After converting the file, I try and add a few of the
numbers in one of the colunms and my answer is always #VALUE; which
tells me
those numbers are being read as values and not numbers. HOW do I import
the
file or what changes do I need to make in order to get those numbers to
be
seen as Numerical after the file is imported?