Loosing Formatting on Data in dropdown box

arshaw · #1 02-21-2013, 06:14 AM

Thanks. I tried that but the spacing varies a little and the numbers don't line up exactly.

OTPM · #2 02-23-2013, 07:52 AM

Hi
Are you able to post a sample so I can take a look for you.
Tony

arshaw · #3 02-26-2013, 11:44 AM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Populate dropdown list with data from Access table	spw4000	Office	0	02-24-2012 05:22 AM
Inserting 'Text from File' without loosing formatting	OverAchiever13	Word	2	05-28-2010 12:24 PM
Merge Documents without loosing formating	dewilk	Word	0	02-23-2010 02:57 PM
Automate Data from Excel into Word DropDown...?	sigraves	Word VBA	0	08-03-2009 06:54 AM
Trouble With Data Validation And Filtering On A Dropdown	zura04	Excel	0	10-24-2006 12:54 PM