Solved

How can I make the combo box shows as currency

Posted on 2009-05-12
10
406 Views
Last Modified: 2012-06-21
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?
0
Comment
Question by:peyyuan
  • 5
  • 4
10 Comments
 
LVL 22

Expert Comment

by:Ivo Stoykov
Comment Utility
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
 

Author Comment

by:peyyuan
Comment Utility
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
 
LVL 22

Expert Comment

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

HTH

Ivo Stoykov
0
 

Author Comment

by:peyyuan
Comment Utility
Can you give more detail of your solution?  or provide a simple example?
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 22

Expert Comment

by:Ivo Stoykov
Comment Utility
Please see attached file. Form Combo is used

HTH

Ivo Stoykov

Combo-Sample.xlsx
0
 

Author Comment

by:peyyuan
Comment Utility
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
 
LVL 22

Expert Comment

by:Ivo Stoykov
Comment Utility
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
 

Author Comment

by:peyyuan
Comment Utility
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
 
LVL 22

Accepted Solution

by:
Ivo Stoykov earned 500 total points
Comment Utility
Here is with ActiveX Combo. I've converted it from 2007 to 2003 format
HTH
Ivo Stoykov

Test.xls
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now