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

[jha900]

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

[LegareColeman]

If the cell is A1 on worksheet Sheet1, then:

<pre> Worksheets("Sheet1").Range("A1").Value = "n=" & Worksheets("Sheet1").Range("A1").Value
</pre>


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

<pre> ActiveCell.Value = "n=" & ActiveCell.Value
</pre>

[charlotte]

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

[SammyB]

In order to keep the 317 in the cell as a number, I would just change the format:
<pre> Selection.NumberFormat = """n=""General"
</pre>