Results 1 to 3 of 3

Thread: formatting a cell

  1. #1

    Thread Starter
    New Member
    Join Date
    Oct 2000
    Location
    montreal
    Posts
    13

    Exclamation

    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

  2. #2
    Guest
    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.

  3. #3
    Lively Member flint's Avatar
    Join Date
    Oct 2000
    Posts
    67
    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


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width