software

I have used Access quot;Toolsquot; to analyze a query with Exel but can't get Exel to
then total a field without reentering all the numbers in the field. If this
makes any sense to anyone, please help me figure out how to make it work.
Thank you.

Hi,
when Access exports numbers, it often does so as text. To fix this follow:

Enter a 1 into any blank cell
Copy it
Select all your 'numbers' that you wish to convert to true numbers
Editgt;Paste Special MULTIPLY amp; values

et voila
--
Rgds, Geoff

quot;A crash reduces
Your expensive computer
To a simple stonequot;quot;Bevatronquot; wrote:

gt; I have used Access quot;Toolsquot; to analyze a query with Exel but can't get Exel to
gt; then total a field without reentering all the numbers in the field. If this
gt; makes any sense to anyone, please help me figure out how to make it work.
gt; Thank you.

et voila!!! You were so correct! I did have to make the 1 a number cell
prior to copying, but it worked. You have saved me much work and
aggrevation. Thank you.

quot;xlboquot; wrote:

gt; Hi,
gt; when Access exports numbers, it often does so as text. To fix this follow:
gt;
gt; Enter a 1 into any blank cell
gt; Copy it
gt; Select all your 'numbers' that you wish to convert to true numbers
gt; Editgt;Paste Special MULTIPLY amp; values
gt;
gt; et voila
gt; --
gt; Rgds, Geoff
gt;
gt; quot;A crash reduces
gt; Your expensive computer
gt; To a simple stonequot;
gt;
gt;
gt; quot;Bevatronquot; wrote:
gt;
gt; gt; I have used Access quot;Toolsquot; to analyze a query with Exel but can't get Exel to
gt; gt; then total a field without reentering all the numbers in the field. If this
gt; gt; makes any sense to anyone, please help me figure out how to make it work.
gt; gt; Thank you.