| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I format data from access to work in excel calculations?
I am wanting to import data from a table in Access, which I've done, but need
the numbers to work in Excel formulae. The numbers are importing fine, but the calculations are not happening, unless I go in to the Excel worksheet and retype the numbers...then the formula will work...but this is redundant any ideas how to format the data? or to prepare the data prior to importation? I need this data to import and display without having to re-key the data. Thanks for the insight. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I format data from access to work in excel calculations?
Debra Dalgleish shares some techniques:
http://www.contextures.com/xlDataEntry03.html Phil wrote: I am wanting to import data from a table in Access, which I've done, but need the numbers to work in Excel formulae. The numbers are importing fine, but the calculations are not happening, unless I go in to the Excel worksheet and retype the numbers...then the formula will work...but this is redundant any ideas how to format the data? or to prepare the data prior to importation? I need this data to import and display without having to re-key the data. Thanks for the insight. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I format data from access to work in excel calculations
Thanks Dave, as this info is helpful, the format application does not affect
the imported data from Access, only data added directly to the excel spreadsheet. "Dave Peterson" wrote: Debra Dalgleish shares some techniques: http://www.contextures.com/xlDataEntry03.html Phil wrote: I am wanting to import data from a table in Access, which I've done, but need the numbers to work in Excel formulae. The numbers are importing fine, but the calculations are not happening, unless I go in to the Excel worksheet and retype the numbers...then the formula will work...but this is redundant any ideas how to format the data? or to prepare the data prior to importation? I need this data to import and display without having to re-key the data. Thanks for the insight. -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I format data from access to work in excel calculations
Make sure that the cells are formatted as General (or anything but Text) before
you type your entries. If you've already typed the entries (and they're seen as Text), then Debra's techniques should work ok. Phil wrote: Thanks Dave, as this info is helpful, the format application does not affect the imported data from Access, only data added directly to the excel spreadsheet. "Dave Peterson" wrote: Debra Dalgleish shares some techniques: http://www.contextures.com/xlDataEntry03.html Phil wrote: I am wanting to import data from a table in Access, which I've done, but need the numbers to work in Excel formulae. The numbers are importing fine, but the calculations are not happening, unless I go in to the Excel worksheet and retype the numbers...then the formula will work...but this is redundant any ideas how to format the data? or to prepare the data prior to importation? I need this data to import and display without having to re-key the data. Thanks for the insight. -- Dave Peterson -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I format data from access to work in excel calculations
Thanks ... I found that the issue was in the format of the Access fields -
"text" , it could not be reformatted once it got to the excel spreadsheet... it needed to have been in the correct format in Access -prior- to the data transfer.... I appreciate your time, thanks again! "Dave Peterson" wrote: Make sure that the cells are formatted as General (or anything but Text) before you type your entries. If you've already typed the entries (and they're seen as Text), then Debra's techniques should work ok. Phil wrote: Thanks Dave, as this info is helpful, the format application does not affect the imported data from Access, only data added directly to the excel spreadsheet. "Dave Peterson" wrote: Debra Dalgleish shares some techniques: http://www.contextures.com/xlDataEntry03.html Phil wrote: I am wanting to import data from a table in Access, which I've done, but need the numbers to work in Excel formulae. The numbers are importing fine, but the calculations are not happening, unless I go in to the Excel worksheet and retype the numbers...then the formula will work...but this is redundant any ideas how to format the data? or to prepare the data prior to importation? I need this data to import and display without having to re-key the data. Thanks for the insight. -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date Format Issues Access to Excel | Excel Discussion (Misc queries) | |||
| Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
| access dates in excel, how to change format? | Excel Discussion (Misc queries) | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Hybrid Mode
