Are you saying you need to split your imported text ?
....Or are your numbers being seen as text ?
----- Original Message -----
From: Stefan Nilsson <[log in to unmask]>
To: <[log in to unmask]>
Sent: Tuesday, March 20, 2001 9:37 PM
Subject: Re: Strange cell format
: Thank you Dave, but when you use MS query there is no
: option the data should come in to the table as it was
defined in the
: data base.
: The Data/'text to columns' wizard was able to fix a column
: time(thanks to Fenwick Scott).
: I'll write some code going through column by column after
: update/requery, but it sure would be nice to stop it from
: alltogether during data retrival.
: ______________________________ Reply Separator
: Subject: Re: Strange cell format
: Author: [log in to unmask] at Internet-europe
: Date: 2001-03-20 19:14
: Hi Stefan
: When you import into Excel you should be given the option to
: import as text or numbers!
: If you have numbers that are acting as text then either:
: 1. Place the number 1 in any cell and then copy it. Select
: your data and Pastespecial-Multiply over your numbers.
: 2. Use =Value(A1) and copy down
: ----- Original Message -----