View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nicole
 
Posts: n/a
Default 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.