if a cell has data, add suffix "N"
 

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.

if a cell has data, add suffix "N"
 

First select the cells and:

Format Cells... Number Custom General"N"
--
Gary''s Student - gsnu200907

if a cell has data, add suffix "N"
 

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


"Barnet Gill" wrote:

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.

if a cell has data, add suffix "N"
 

"cm" wrote:

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


"Barnet Gill" wrote: Thanks! It works a treat.

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.

if a cell has data, add suffix "N"
 

"Gary''s Student" wrote:

First select the cells and:

Format Cells... Number Custom General"N"
--
Gary''s Student - gsnu200907

Thanks Gary"s Student - job done! Barnet Gill