Feedback by UserVoice

Phillip Johnson

My feedback

  1. 14 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment An error occurred while saving the comment
    Phillip Johnson commented  · 

    I agree that a feature like this has been missing for way too long.

    Please add (1) capability to format the display of cell values to a user specified number of significant figures (also known as significant digits), and (2) functions that round, round-down, round-up to a number of significant figures as an input argument. For reference reading see the following web page which includes links to published papers and more detailed explanation: http://www.angelfire.com/oh/cmulliss/. I am tired of implementing hacks like this: https://www.vertex42.com/ExcelTips/significant-figures.html.

    Phillip Johnson supported this idea  · 
  2. 20 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Phillip Johnson supported this idea  · 
    An error occurred while saving the comment
    Phillip Johnson commented  · 

    I agree that this feature has been missing for way too long. Please add (1) capability to format the display of cell values to a user specified number of significant figures (also known as significant digits), and (2) functions that round, round-down, round-up to a number of significant figures as an input argument. For reference reading see the following web page which includes links to published papers and more detailed explanation: http://www.angelfire.com/oh/cmulliss/. I am tired of implementing hacks like this: https://www.vertex42.com/ExcelTips/significant-figures.html.

  3. 21 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment An error occurred while saving the comment
    Phillip Johnson commented  · 

    @DoctorMoshe: scientific notation with a user set number of digits displayed does achieve the same result as the significant figure format for cell display, however scientific notation is too cumbersome for some purposes and some audiences (non-technical readers)

    An error occurred while saving the comment
    Phillip Johnson commented  · 

    I agree that a feature like this has been missing for way too long, although I do not understand the request to make it automatic. Normally calculations should be carried out using all available significant figures (i.e. all 15 digits available in Excel), and then only the final result for display purposes is rounded to an appropriate number of significant digits. Note that it is important that the display be rounded, while the cell value not be rounded since it may be used in subsequent calculations. I would be satisfied if the number of significant figures to display was determined by the user; but amazed if more functionality was added to trace all precedence inputs to a cell result and automatically round to the appropriate number of sig-figs (assuming that all cells with a number value rather than a formula have a format set to identify the number of significant digits).

    Please add (1) capability to format the display of cell values to a user specified number of significant figures (also known as significant digits), and (2) functions that round, round-down, round-up to a number of significant figures as an input argument. For reference reading see the following web page which includes links to published papers and more detailed explanation: http://www.angelfire.com/oh/cmulliss/. I am tired of implementing hacks like this: https://www.vertex42.com/ExcelTips/significant-figures.html.

    Phillip Johnson supported this idea  · 
  4. 13 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Excel for Mac » Formatting  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Phillip Johnson commented  · 

    I agree that consideration of significant figures (significant digits) has been missing in Excel for way too long. Normally calculations should be carried out using all available significant figures (i.e. all 15 digits available in Excel), and then only the final result for display purposes is rounded to an appropriate number of significant digits. Note that it is important that the display be rounded, while the cell value not be rounded since it may be used in subsequent calculations. I would be satisfied if the number of significant figures to display was determined by the user; but amazed if more functionality was added to trace all precedence inputs to a cell formula result and automatically round to the appropriate number of sig-figs (assuming that all cells with a number value rather than a formula have a format set to identify the number of significant digits).

    Please add (1) capability to format the display of cell values to a user specified number of significant figures (also known as significant digits), and (2) functions that round, round-down, round-up to a number of significant figures as an input argument. For reference reading see the following web page which includes links to published papers and more detailed explanation: http://www.angelfire.com/oh/cmulliss/. I am tired of implementing hacks like this: https://www.vertex42.com/ExcelTips/significant-figures.html.

    Phillip Johnson supported this idea  · 

Feedback and Knowledge Base