Thread: [Solved] Loosing Formatting on Data in dropdown box
View Single Post
 
Old 02-26-2013, 11:44 AM
arshaw arshaw is offline Windows 7 64bit Office 2010 32bit
Novice
  
Join Date: Jan 2013
Posts: 3
arshaw is on a distinguished road
Default Formatting Data in Dropdown box
Tony. Thanks. I had someone write a macro to repopulate the drop down boxes from an excel file. I then formatted the numbers in Excel to be currency and the description in Excel to be text. Everything lines up great now but the numbers don't have the formatting from the excel file. They are missing the $ and the , and if the amount ends with .00 that is also missing.

I'm new at this and I couldn't upload the template. It said invalid file. So I attached the VB code instead.
Attached Files
File Type: xlsx price_list.xlsx (10.1 KB, 12 views)
File Type: docx Sub FillDropDown VB Code.docx (14.5 KB, 10 views)
Last edited by arshaw; 02-26-2013 at 12:20 PM. Reason: Couldn't post file
Reply With Quote