if a cell has data, add suffix "N"

[Barnet Gill]

Using Excel 2003.
I want to add a letter N to the end of a cell which I put a number into.
The number is entered by hand (ie not from another cell reference) and I
would like it to have N as a suffix.

 

[Gary''s Student]

First select the cells and:

Format > Cells... > Number > Custom > General"N"

 

[cm]

you can use a custom cell format: 0"N" to format that cell

 

[Barnet Gill]

you can use a custom cell format: 0"N" to format that cell
--
hope to help,
cm


: Thanks! It works a treat.

 

[Barnet Gill]

First select the cells and:

Format > Cells... > Number > Custom > General"N"

Thanks Gary"s Student - job done! Barnet Gill