Loosing Formatting on Data in dropdown box

arshaw · #1 01-24-2013, 09:34 AM

I added a dropdown box to a template we use to generate a form. I added the data with a tab between the items. After I save and reopen the tabs in the data are gone.

OTPM · #2 02-01-2013, 08:29 AM

Hi
Try using spaces rather than tabs.
Hope this helps.
Good luck
Tony

arshaw · #3 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 · #4 02-23-2013, 07:52 AM

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

arshaw · #5 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.

OTPM · #6 02-26-2013, 12:37 PM

Hi
Without the template I cannot test anything. Try zipping it up end emailing it to me at otpm@blueyonder.co.uk (dont use the email from the forum).
Tony

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