cell formats

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bob Wickham - 17 Jan 2006 23:04 GMT

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

Reply to this Message

Sean - 17 Jan 2006 23:16 GMT

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

Reply to this Message

Bob Wickham - 17 Jan 2006 23:21 GMT

> 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

Reply to this Message

Dave Peterson - 17 Jan 2006 23:28 GMT

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.

> Hi,
> I need to get data from a web site.
[quoted text clipped - 19 lines]
>
> Bob Wickham

Signature

Dave Peterson

Reply to this Message

Bob Wickham - 17 Jan 2006 23:49 GMT

> Formatting the cell as text doesn't change the existing value.
>
[quoted text clipped - 27 lines]
>>
>>Bob Wickham

Thanks Dave,
I'll give that a go.

Reply to this Message