MarkPettitt
IS-IT--Management
Morning all,
I have a peculiar problem, I have an excel document with some totals at the bottom of some columns, results are in £'s.
When I convert to .PDF, the Excel document suddenly changes the £'s to $'s & the .PDF shows $'s.
The weird thing is, you highlight a cell that has been changed to a $, go to 'format cell' & it says its still formatted for £'s!!!!!
Closing the spreadsheet down then opening it seems to solve that one, but still can't sort out the conversion to .PDF
And.........
...we have version 6 & 7, version 6 converts fine, version 7 is the one that is causing the problem?
Checked all the dictionaries, options etc for anything obvious but I must be missing something somewhere
thanks for any help
I have a peculiar problem, I have an excel document with some totals at the bottom of some columns, results are in £'s.
When I convert to .PDF, the Excel document suddenly changes the £'s to $'s & the .PDF shows $'s.
The weird thing is, you highlight a cell that has been changed to a $, go to 'format cell' & it says its still formatted for £'s!!!!!
Closing the spreadsheet down then opening it seems to solve that one, but still can't sort out the conversion to .PDF
And.........
...we have version 6 & 7, version 6 converts fine, version 7 is the one that is causing the problem?
Checked all the dictionaries, options etc for anything obvious but I must be missing something somewhere
thanks for any help