Posted to microsoft.public.excel.programming

SMonczka

external usenet poster

Posts: 33

Formating Combo Boxes

I have a combo box that references a range. Both the range and the
linked cell are formated for 00%. The drop down list in the combo box
shows 10%,20%,30%. But everytime i select on of the items from the
dropdown list I return a value of .1,.2 or .3 depending on what I
selected. I have looked through the forums but have been unable to
locate a fix for this. Can someone please help me.

Thanks
Steve Monczka

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Getting Combo boxes to change options based on other Combo boxes.	Ancient Wolf	New Users to Excel	1	March 27th 09 06:29 PM
Selecting subsets using combo boxes or list boxes	CLamar	Excel Discussion (Misc queries)	0	June 1st 06 07:43 PM
Questions on combo boxes and list boxes.	Marc	New Users to Excel	1	March 14th 06 09:40 AM
Combo Boxes and Tick Boxes	turner2000[_2_]	Excel Programming	0	September 29th 04 09:09 PM
Combo Boxes and Tick Boxes	turner2000	Excel Programming	0	September 28th 04 10:01 PM

All times are GMT +1. The time now is 06:15 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us