Thread: adding text
View Single Post
  #4   Report Post  
Jay
 
Posts: n/a
Default

I have a column of numbers. I want to add "shercs" to them all w/o
having to type the whole column over. Is this possible


One way is to use:
Format cells Number Custom
And put something like this in the "Type"
#,##0.00 "shercs"

This changes the display of the numbers, but the cells still are numeric.
So you can use them in arithmetic formulas.