Skip to main content
Question

Add the 'Pound' symbol to a number format

P
Forum|alt.badge.img

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 £.

    3 replies

    fmelizard
    Safer
    Forum|alt.badge.img+18
    • fmelizardSafer
    • Safer
    • January 29, 2018

    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.

    P
    Forum|alt.badge.img
    • p80cey
    • Author
    • January 30, 2018
    fmelizard wrote:

    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.

    Thanks for testing and advising on 2018. The workbench will be run through Server 2017 so we would need to test that a 2018 workbench would run through Server 2017.

     

     

    P
    Forum|alt.badge.img
    • p80cey
    • Author
    • January 31, 2018

    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.

    Reply


    Helpful Members This Week

    Community Stats

    31,260
    Posts
    118,546
    Replies
    38,851
    Members

    Latest FME

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings
    A product of
    Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.