View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CM CM is offline
external usenet poster
 
Posts: 136
Default 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.