Thanks Clive,
Excel is a new planet for me! I found "Insert Function" but TYPE was
not listed.
Can you describe the method please?
I have visibly checked in Excel and the number looks OK. There are no
additional characters that I can see,
Cheers,
Robin
At 4/10/2011 11:22 AM, you wrote:
>Hi Robin,
>
>Make a copy of the .csv file and open it with Excel.
>
>If you can't see anything wrong with the numbers
>then try using the Excel TYPE function in an empty
>column to the left of the suspect values and see what
>value is returned.
>
>If value is: TYPE returns:
>Number 1
>Text 2
>Logical value 4
>Error value 16
>Array 64
>
>The values returned should all be Type 1.
>
>Alternatively, you can open the .csv file with a
>text editor program like NotePad, Wordpad, or TextPad
>and see if you can see anything peculiar about the
>supect "numbers".
>
>A possible fault could be that the 'nubers' have a
>prefix and number nine looks like '9 instead of 9.
>
>Regards, Clive.
>
>--- In MS_Access_Professionals@yahoogroups.com, Robin Chapple
><robinski@...> wrote:
> >
> > I have a statistical report delivered as a CSV file which shows an
> > error, - #Num! , in a limited number of cases, 7 out of 811, when
> > linked to Access.
> >
> > The CSV file has all numbers recorded.
> >
> > Where do I look for a solution to the problem?
> >
> > Many thanks,
> >
> > Robin Chapple
> >
>
>
>
>
>------------------------------------
>
>Yahoo! Groups Links
>
>
>
Tidak ada komentar:
Posting Komentar