View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
GILBERT GILBERT is offline
external usenet poster
 
Posts: 74
Default Add an inches sign to many rows

Type the " in a cel, then use the concatenate formula. You can then paste
your results in the original column.

"Denise" wrote:

I have a spreadsheet that has a number in each row that doesn't have an "
inch sign. I want to add an " sign to each of the cells next to the number
without have to manual put in ". i.e. 29.3 29.3"

Is there a special trick?

Denise

--
Denise B.