Convert $ amount from excel to access? No decimals but 00 at end

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access stripping decimal places in query 1
excel 2003 zero as last decimal 5
Dollars to text without loosing zeros from decimal places 5
Convert number to text as displayed 3
why do zeros after decimals drop out of excel 3
Round a repeating decimal from a formula... 14
Merge data from xcel to word 3
Conversions of Decimal Feet to Decimal Inches - Formula?? 0

Back
Top