Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I noramlly use the Text function to convert values. How do
I do it in VBA? I tried ActiveCell.Value = Application.WorksheetFunction.Text(ActiveCell.Valu e, "0") but it didn't work. Thanks in advance for any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Assigning strings number values and adding them together | Excel Worksheet Functions | |||
Convert a 8X3 table to a vertical range of the Unique strings only | Excel Worksheet Functions | |||
Assigning number values to text strings | Excel Discussion (Misc queries) | |||
Convert text strings to a code or number | Excel Worksheet Functions | |||
VB Assigning Values to a Series of Strings | Excel Discussion (Misc queries) |