Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Analyze with Excel from Access
I have used Access "Tools" 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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Analyze with Excel from Access
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 EditPaste Special MULTIPLY & values et voila -- Rgds, Geoff "A crash reduces Your expensive computer To a simple stone" "Bevatron" wrote: I have used Access "Tools" 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Analyze with Excel from Access
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. "xlbo" wrote: 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 EditPaste Special MULTIPLY & values et voila -- Rgds, Geoff "A crash reduces Your expensive computer To a simple stone" "Bevatron" wrote: I have used Access "Tools" 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transferring data from MS Access to MS Excel | Excel Discussion (Misc queries) | |||
Excel Access and Oracle | Excel Discussion (Misc queries) | |||
Using Access database to "populate" Excel Sheets | Excel Discussion (Misc queries) | |||
Excel won't open - pasting from Access | Excel Discussion (Misc queries) | |||
MS Access in Excel | Excel Worksheet Functions |