Ask Your Question

I cannot remove the ' character from a column of cells

asked 2017-11-20 18:43:47 +0200

Kaelkitty gravatar image

I cant get this column to sum. It is supposed to be currency formatted but when I have been messing about I have discovered that the data in the column all start with a hidden ' ie. '$2.00 I have tried various format commands from the menu, as well as some of the options that popup when right clicking in the cell, nothing seems to work! I f I manually show the contents of one cell in the edit bar and remove the ' by hand the calculation works, but it seems there should be a better solution than doing that 193 times!

Ciao, KK.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-11-20 18:52:01 +0200

pierre-yves samyn gravatar image


Select the range then DataText to ColumnsOk

Warn: do not use this technique if some cells contain a formula, it will be removed


edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-11-20 18:43:47 +0200

Seen: 963 times

Last updated: Nov 20 '17