We are running FME desktop 2017 and are struggling to do a custom number format that will show the 'pound' symbol when writing to a new Excel sheet. shows a '?' symbol instead. the doller '$' works fine. We have changed the font to Arial and checked the character encode and it still wont display the £.
Question
Add the 'Pound' symbol to a number format
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+21- Safer
Hi @p80cey,
Thanks for reporting this. I tested this out and I see exactly what you mean. I did test this in the latest FME 2018.0 beta and it seems to be working there. Are you able to use the FME beta as a workaround? You can have more than one version of FME installed on your machine. Just be sure to install the new version into a seperate directory.
Hi @p80cey,
Thanks for reporting this. I tested this out and I see exactly what you mean. I did test this in the latest FME 2018.0 beta and it seems to be working there. Are you able to use the FME beta as a workaround? You can have more than one version of FME installed on your machine. Just be sure to install the new version into a seperate directory.
Hi @MattAtSafe,
Thanks again for getting back to me. Your example worked a treat! I feel such a nelly as I should have come to that conclusion myself.. your awesomeness has been noted, keep this up and you will soon be working the milkshake counter at Safe.
Thanks again.