How can I make the combo box shows as currency

I am using Combo box to display 7 level of prices but after you select the dollar amount the cell will only show as number without dollar sign.  I've tried to format the cell as currency or accounting before I link the combo box did not work.  I also tried to use currency in my name list but still won't work, it will display currency sign when it shows as a list but as soon as you made the selection the currency sign disappeared.  Any solution for this?
peyyuanAsked:
Who is Participating?
 
Ivo StoykovConnect With a Mentor Commented:
Here is with ActiveX Combo. I've converted it from 2007 to 2003 format
HTH
Ivo Stoykov

Test.xls
0
 
Ivo StoykovCommented:
How do you make your combo - Data / Validation / List or
Form / DropDown List?
If former is the case just format range and list cell(s) as currency. Should work...
if latter is the case you should set value properly formated - it is just a string.
HTH
Ivo Stoykov
0
 
peyyuanAuthor Commented:
I am using the combo box from the tool box not validation, it works when I use validation but not works when I change it to the Combo box from the tool bar.
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Ivo StoykovCommented:
I'm afraid you convert it to string and format is as currency for each line in the combo...

HTH

Ivo Stoykov
0
 
peyyuanAuthor Commented:
Can you give more detail of your solution?  or provide a simple example?
0
 
Ivo StoykovCommented:
Please see attached file. Form Combo is used

HTH

Ivo Stoykov

Combo-Sample.xlsx
0
 
peyyuanAuthor Commented:
Is there any reason I can't check the porperty of your combo box??  I notice your box was called Drop Down 1, did you create the box in other method or because I am viewing your file by 2003 excel??  Sorry, I was not advanced as you are .
0
 
Ivo StoykovCommented:
this is Excel 2007

I've just drag&drop the combo from FORMS not ActiveX, filled some cells, formatted them and set combo to reference to them.

That's all

Ivo Stoykov
0
 
peyyuanAuthor Commented:
In my case I don't think I can use combo box from FORM.  I have cell in other sheet that will link to the value to the linked cell.  I notice when you use combo box from form the value returned in the linked cell not equal to the data that shows in the drop down list.  If I choose the 2nd one from the list the value in the link cell will display 2 instead of the choice I made. However I do appreciate that you show me an other way to make combo box.  Any other suggestion?
0
All Courses

From novice to tech pro — start learning today.