You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register
    • Get Started: AI Resources for Oracle Cloud HCM – Go Here

    Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

    Number Formatting switching to Custom after saving report

    edited Dec 14, 2022 6:44AM in Taleo Business Edition (TBE) 3 comments

    Summary

    I have a report that keeps formatting numbers as text when exporting to excel document, despite setting formatting in report

    Content

    Hi All,

    I'm having an issue with a report that exports numbers as text to excel, even though I am setting a format to number, with no decimals.

    The report uses expressions to count a requisition (1) if it is open, and then I use the summation function to add up the requisitions, giving a number (i.e. 14 open positions).

    I've set the formatting to number, with zero decimal points, but when I export the report to excel, all the numbers show as "Number formatted as text". When I return to the report, the formatting shows as "Custom", rather than the number (with zero decimal points) that I set and saved it as.

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!