Thank you so much. It worked.
--
Denise B.


"FSt1" wrote:

hi
try this;
if number is in A2, in B2 use formula
=A2&""""
copy the formula down as far as needed. copy B column and paste special
values.
delete A column.
adjust cell references to fit your data.
note: in doing the above, you loose all ability to do math with the numbers.
with the inch sign, excel looks at the numbers a text.

regards
FSt1

"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.