cell formats

[Bob Wickham]

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

[Sean]

Does double-clicking the column header to "Auto Fit" remove the
scientific notation and expand the full number?
Sean

[Bob Wickham]

Sean wrote:
> Does double-clicking the column header to "Auto Fit" remove the
> scientific notation and expand the full number?
> Sean
>
Hi Sean,
No it doesn't.

Bob

[Dave Peterson]

Formatting the cell as text doesn't change the existing value.

I'd download the .csv file, but save it as .txt.

Then use file|open to open that .txt file.
You'll see the text import wizard open up and you can specify Text for the
fields you want treated as text.

Bob Wickham wrote:
>
> 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

--

Dave Peterson

[Bob Wickham]

Dave Peterson wrote:
> Formatting the cell as text doesn't change the existing value.
>
> I'd download the .csv file, but save it as .txt.
>
> Then use file|open to open that .txt file.
> You'll see the text import wizard open up and you can specify Text for the
> fields you want treated as text.
>
> Bob Wickham wrote:
>
>>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
>
>
Thanks Dave,
I'll give that a go.