£ printing as $

[huzz456]

Hi

I've tried searching to find the solution to this but cant seem to find anyone having this problem before. Seems like its something obvious I'm missing but cant work out what it is!

I'm using the code below to automate the process of printing 3 hidden sheets of a workbook. The content is a lot of financial stuff and there are a lot of '£' signs involved but when using the macro to print, all '£' signs are printed as '$' signs. When printing normally through the menu system in Excel this doesn't happen and all is printed correctly. I've tried on different computers with different printers and the same thing happens.

I'm on an iMac with High Sierra running Excel 2016 version 15.39.

VBA Code:

<code style="margin: 0px; padding: 0px; font-style: inherit; line-height: 12px;">Sub PrintAll()

Application.ScreenUpdating = False
Sheets("Print Version").Visible = True
Sheets("Print Version").PrintOut
Sheets("Print Version").Visible = False

Sheets("Manager's Copy").Visible = True
Sheets("Manager's Copy").PrintOut
Sheets("Manager's Copy").Visible = False

Sheets("Weekly Return").Visible = True
Sheets("Weekly Return").PrintOut
Sheets("Weekly Return").Visible = False
Application.ScreenUpdating = True

End Sub</code>


Many thanks

Pete

 

[mole999]

american keyboard layout ?

 

[huzz456]

That was my first thought but everywhere I can think to look on my computer has UK layout selected. Is there somewhere in particular I should be checking? It doesn't make sense that printing normally isn't effected though does it?

 

[mole999]

do you use a finance format for the cells ?

 

[huzz456]

Re: £ printing as $

do you use a finance format for the cells ?

Aha! Yes that does seem to be the problem. I had no idea that there was a specific United Kingdom £ sign which was different to the standard £ sign format. So instead of having it all formatted as currency with £ it needs to be formatted as currency with [$£-809]. Many thanks for your help!