formatting a cell

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:).

Code:

---

    Range(A1, B1).NumberFormat = "Text"

---

The value is anything you see in the Category List with "Custom" replaced by "NumberFormat".

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:

Code:

---

Activesheet.Range("C6").Select
Selection.NumberFormat = "@"

---

To format a text field here's what I use:

Code:

---

txtField.Text = Format(txtField, "General")

---

Flint