| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if a cell has data, add suffix "N"
First select the cells and:
Format Cells... Number Custom General"N" -- Gary''s Student - gsnu200907 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| "CELL("FILENAME") NOT UPDATE AFTER "SAVE AS" ACTION | Excel Discussion (Misc queries) | |||
| Help!!! Enter "7" in a cell and Excel changes the "7" to "11" immediately!!! | Excel Discussion (Misc queries) | |||
| Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" | Excel Discussion (Misc queries) | |||
| Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
Linear Mode
