Hi,
I need to get data from a web site.
I can, either, click > drag > copy the web site table and then paste
into Excel
OR
I can download a csv file from the web site.
Either way, a column in the resulting spreadsheet is populated with 12
digit numbers formatted as General.
The problem is, a number that should appear as 464140530360
is shown as 4.64141E+11
The only way I can get it to appear as 12 digits is to format it as a
Number with no decimal places.
What I'd really prefer is to format it as Text because its eventually to
go into Access and it doesn't require any calculations done on it.
But formatting it as Text in the spreadsheet shows it as 4.64141E+11.
Do you think its something I can change at the Excel end or should I
fiddle with it once its in Access.
Thanks,
Bob Wickham
Bookmarks