Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert $ amount from excel to access? No decimals but 00 at end
I am trying to export dollar amounts from excel to Acess. Access does not use
decimals so I need to remove the decimals from the cells in Excel but add the two zeros to serve as place holders at the end of the number. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert $ amount from excel to access? No decimals but 00 at end
Not sure if I'm understanding you properly. Microsoft Access definitely does
accept numbers with trailing decimals. If you are exportiing dollar amounts format your Access field as a Currency field. I am going to take a guess and assume that all the dollar amounts you are exporting to Access are even dollar amounts ($500.00, $999.00, $1.00, etc). If that is the case make sure that the field you are putting these into in Access is formatted to show 2 trailing decimal places whether there is data in those trailing spaces or not. "Nicole" wrote: I am trying to export dollar amounts from excel to Acess. Access does not use decimals so I need to remove the decimals from the cells in Excel but add the two zeros to serve as place holders at the end of the number. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert MS Excel data to MS Access database | Excel Worksheet Functions | |||
Access Excel Linked Text and Number Issues | Excel Discussion (Misc queries) | |||
Using Access database to "populate" Excel Sheets | Excel Discussion (Misc queries) | |||
Changing the format of an Excel output file made by Microsoft Access | Excel Discussion (Misc queries) | |||
Excel user desires to learn ABC of Access | Excel Discussion (Misc queries) |