G
Guest
Hello,
I have a column of numbers that have the comment "The number in this cell is
formatted as text or preceded by an apostrophe". I'd like to convert all
these these values to numbers so I can get a summation. By mousing over the
cell I can get a menu that allows me to convert the numbers one at a time,
but how can I convert them all at once?
I've tried converting with the Format/Cells and Edit/Copy/PasteSpecial/values.
Thanks in advance,
Ellen
I have a column of numbers that have the comment "The number in this cell is
formatted as text or preceded by an apostrophe". I'd like to convert all
these these values to numbers so I can get a summation. By mousing over the
cell I can get a menu that allows me to convert the numbers one at a time,
but how can I convert them all at once?
I've tried converting with the Format/Cells and Edit/Copy/PasteSpecial/values.
Thanks in advance,
Ellen