Skip to Content
0
Former Member
Sep 28, 2005 at 05:52 PM

How to remove leading ' in workbook?

17 Views

Hi,

we are reporting queries via workbooks.

Yet, all values in the workbook (in the data area) start with 'xxx. eg. Instead of showing 3 it's showing: '3 as the content of excel cell.

How can I change my workbook in such a way (maybe via Format -> Style) that it automatically removes this '?

Regards,

Hans