Select the cells in which you want the 1
Choose FormatCells
On the Number tab, choose Custom
In the text box, type: @" 1"
Click OK


Stinky wrote:
i have 2 cells in my worksheet that i want a "1" to be added at the end of
whatever i type in the cell.

for example,

i type a value of "los angeles" in a1. i want to see "los angeles1" in the
cell a1


any help would be appreciated


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html