Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing text to numberformat via textbox on a form
I use textboxes on a form to enter various data to some cells in a spreadsheet. (Not a table). All values are saved as text regardless of if they are actually numbers. So I tried ths:
.... With Range("MyCell") .Value = TextBox3 .NumberFormat = "#,##0" End With .... The cell is now formatted as a number but I have to doubleclick it to appear as a number as it still looks like text and the green little mark says it has been saved as text! How do I get around this? Regards Stef |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing text to numberformat via textbox on a form
Hi Stef
Formatting as number will not convert text to numbers. Why is it text in the first place ? Shouldn't be. Anyway, you can force a number-lookalike text to be number by multiplying it by 1: Private Sub CommandButton1_Click() With Range("MyCell") .Value = TextBox3.Text .Value = .Value * 1 .NumberFormat = "#,##0" End With End Sub HTH. Best wishes Harald "Stef" skrev i melding ... I use textboxes on a form to enter various data to some cells in a spreadsheet. (Not a table). All values are saved as text regardless of if they are actually numbers. So I tried ths: ... With Range("MyCell") .Value = TextBox3 .NumberFormat = "#,##0" End With ... The cell is now formatted as a number but I have to doubleclick it to appear as a number as it still looks like text and the green little mark says it has been saved as text! How do I get around this? Regards Stef |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing text to numberformat via textbox on a form
Thanks! your tip fixed my problem. I do not know for sure but using textboxes to enter data from a form seems to save this data as text by default.
Stef "Harald Staff" wrote: Hi Stef Formatting as number will not convert text to numbers. Why is it text in the first place ? Shouldn't be. Anyway, you can force a number-lookalike text to be number by multiplying it by 1: Private Sub CommandButton1_Click() With Range("MyCell") .Value = TextBox3.Text .Value = .Value * 1 .NumberFormat = "#,##0" End With End Sub HTH. Best wishes Harald "Stef" skrev i melding ... I use textboxes on a form to enter various data to some cells in a spreadsheet. (Not a table). All values are saved as text regardless of if they are actually numbers. So I tried ths: ... With Range("MyCell") .Value = TextBox3 .NumberFormat = "#,##0" End With ... The cell is now formatted as a number but I have to doubleclick it to appear as a number as it still looks like text and the green little mark says it has been saved as text! How do I get around this? Regards Stef |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing text to numberformat via textbox on a form
Private Sub CommandButton1_Click()
With Range("MyCell") .Value = cdbl(TextBox3.Text) ' or clng(Textbox3.Text) .NumberFormat = "#,##0" End With End Sub Everything in a textbox is text. -- Regards, Tom Ogilvy "Stef" wrote in message ... I use textboxes on a form to enter various data to some cells in a spreadsheet. (Not a table). All values are saved as text regardless of if they are actually numbers. So I tried ths: ... With Range("MyCell") .Value = TextBox3 .NumberFormat = "#,##0" End With ... The cell is now formatted as a number but I have to doubleclick it to appear as a number as it still looks like text and the green little mark says it has been saved as text! How do I get around this? Regards Stef |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text Size in Label or Textbox in Form | Excel Discussion (Misc queries) | |||
Form Button - Changing Text | Excel Discussion (Misc queries) | |||
changing a text value to a number value in a textbox? | Excel Programming | |||
textbox on form | Excel Programming | |||
Text to Form Textbox and back | Excel Programming |