SharePoint
Feedback by UserVoice

I suggest you ....

Fix TEXT function bug for scientific notation.

When using the TEXT function in Calculated Columns, the TEXT function adds some extra zeros to the end of the formatted number. For example, for .00000001, TEXT([Number],"0.00E+00") generates this output "1.00E+800" instead of "1.00E+08". (TEXT works correctly in Excel.)

1 vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Mike Smith shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base