a question i wanna format a cell
to be a text
cell
can you help with it
like
worksheets.range("a2").format(text)
thanks you
Printable View
a question i wanna format a cell
to be a text
cell
can you help with it
like
worksheets.range("a2").format(text)
thanks you
Time to lend a hand:).
The value is anything you see in the Category List with "Custom" replaced by "NumberFormat".Code:Range(A1, B1).NumberFormat = "Text"
Hope it helps:D.
Try recording a macro in Excel to see see how to format a cell. There are many ways to go with this.
Try something like this:
To format a text field here's what I use:Code:Activesheet.Range("C6").Select
Selection.NumberFormat = "@"
FlintCode:txtField.Text = Format(txtField, "General")