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 -----
From: Stefan Nilsson <[log in to unmask]>
To: <[log in to unmask]>
Sent: Tuesday, March 20, 2001 6:51 PM
Subject: Strange cell format
: When I extract data from MS query to Excel, some cell's
got a strange
: Right clicking on the cell and picking 'Format Cells..'
: trying to change the format wont work, the sample will
stay the same.
: The only way to get the cell to work as it should is enter
: cell(F2) and hit return without changing anything, after
that it will
: Anyone know why this is happening and how to solve it ?
: I have a small(18kb) .xls where the problem exists, I can
mail this to
: anyone who want to check it out.