Removing the thousands separator from value in combo box

[Glove303]

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.

 

[mole999]

Format Cells > Number, and remove the tick for 1000's,

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

 

[Glove303]

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.

 

[mole999]

not something I use so, unfamiliar, this might help

http://excel.tips.net/Pages/T002387_Formatting_Combo_Box_Text.html

 

[Ruddles]

the data isn't even linked to a cell, it is calculated in VB.

Can you show us the code which adds the item to the combobox?

 

[Glove303]

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.

 

[Ruddles]

Ticket.StopPrice_Box.Value = Application.WorksheetFunction.Fixed
((Ticket.Order_Box.Value + (Ticket.StopPips_Box.Value / iFact)), iDec[COLOR=red][B], True[/B][/COLOR])

 

[Rasm]

try

textbox1.text = format(VariableName,"######.##")

 

[Glove303]

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.