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. |
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. |
All times are GMT +1. The time now is 09:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com