Removing the thousands separator from value in combo box

Glove303

Board Regular
Joined
Dec 18, 2010
Messages
65
Title says it all more or less.

I want to deal with values in combo boxes but I don't want to the thousands separator shown.

Can anyone help me with this?

Thanks in advance.

James.
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
Format Cells > Number, and remove the tick for 1000's,

it could also be linked to your machine set up, for country
 
Upvote 0
Format Cells > Number, and remove the tick for 1000's,

it could also be linked to your machine set up, for country
Cheers.

What about when I'm working directly in a combo box though? So the data isn't even linked to a cell, it is calculated in VB.
 
Upvote 0
Can you show us the code which adds the item to the combobox?
I just realised I made a big mistake in this thread, I actually mean a text box, not a combo box. Sorry, I must be tired. I'm not sure if it changes much though.

Here is the code:

Ticket.StopPrice_Box.Value = Application.WorksheetFunction.Fixed((Ticket.Order_Box.Value + (Ticket.StopPips_Box.Value / iFact)), iDec)

StopPrice_Box is the text box I am wanting to remove the separator from. iFact and iDec are variables I have created. Ticket is the name of the form.
 
Upvote 0
Code:
Ticket.StopPrice_Box.Value = Application.WorksheetFunction.Fixed
((Ticket.Order_Box.Value + (Ticket.StopPips_Box.Value / iFact)), iDec[COLOR=red][B], True[/B][/COLOR])
 
Upvote 0
Code:
Ticket.StopPrice_Box.Value = Application.WorksheetFunction.Fixed
((Ticket.Order_Box.Value + (Ticket.StopPips_Box.Value / iFact)), iDec[COLOR=red][B], True[/B][/COLOR])

That's perfect, I knew there had to an easy and simple solution. Just exactly what I wanted, thank you very much!.

Rasm, thanks too, that method would also work.
 
Upvote 0

Forum statistics

Threads
1,213,484
Messages
6,113,924
Members
448,533
Latest member
thietbibeboiwasaco

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top