If someone sends you a .xls and certain formulas don’t work because the cells have a leading tick in them, here’s a quick solution on how to remove them: http://www.ryananddebi.com/2009/11/29/remove-apostrophes-before-numbers-in-openoffice-calc/
OpenOffice Calc: Replace leading ticks in cells [link]
Leave a reply