Add ‘n=’ to an ActiveCell (officexp, win 2000)

Topic

New Reply

I have a cell with the number 317 in it. I want to add n = before the 317 so it become n = 317. How do i do this using vba? Thanks

Reply | Quote

Replies

If the cell is A1 on worksheet Sheet1, then:

    Worksheets("Sheet1").Range("A1").Value = "n=" & Worksheets("Sheet1").Range("A1").Value

If you really meant the active cell as the subject says, then:

    ActiveCell.Value = "n=" & ActiveCell.Value

Reply | Quote

However, in either case, you no longer have a number, you have a string.

Reply | Quote

In order to keep the 317 in the cell as a number, I would just change the format:

    Selection.NumberFormat = """n=""General"

Reply | Quote