Mike
My feedback

21 votes12 comments · Excel for Windows (Desktop Application) » Editing · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment An error occurred while saving the comment Mike commentedThere are three ways to handle this, as a formula, as a number format category and as a custom number format. I think that all three are necessary and easy.
The formula would work just like ROUND but truncate to number of significant digits rather than just number of digits. Notice the trailing zeros, they are important.
SIGFIG(2017, 2) = 2000
SIGFIG(2.017, 2) = 2.0
SIGFIG(0.2017, 2) = 0.20The number format would operate like the Number, Currency, Accounting, and Percentage categories, with a simple selector to determine the number of digits.
The custom number format should look something like: “ !! “ to round to 2 significant figures and “ !!!!! “ to round to 5 significant figures. It would not matter if the number was an integer or a decimal.
2017 with “ !! “ = 2000
2017 with “ !!!!! “ = 2017.0
2.017 with “ !! “ = 2.0The formula should absolutely truncate the resulting number such that future calculations only use the digits displayed. Whether the number formats truly truncate or just alter what is displayed (while leaving the original value alone) I will leave to brighter minds.
I would also like to see the outlined options dynamically enabled. By this I mean:
round A1 to match the significant digits of cell A2, preferably without having to resort to some LEN formula.Something like SIGFIG(A1, A2) or SIGFIG(2017, A2)
Mike supported this idea · 
2 votes0 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →Mike supported this idea ·

1 vote0 comments · Excel for Windows (Desktop Application) » Performance · Flag idea as inappropriate… · Admin →Mike shared this idea ·

20 votes10 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Mike commentedThere are three ways to handle this, as a formula, as a number format category and as a custom number format. I think that all three are necessary and easy.
The formula would work just like ROUND but truncate to number of significant digits rather than just number of digits. Notice the trailing zeros, they are important.
SIGFIG(2017, 2) = 2000
SIGFIG(2.017, 2) = 2.0
SIGFIG(0.2017, 2) = 0.20The number format would operate like the Number, Currency, Accounting, and Percentage categories, with a simple selector to determine the number of digits.
The custom number format should look something like: “ !! “ to round to 2 significant figures and “ !!!!! “ to round to 5 significant figures. It would not matter if the number was an integer or a decimal.
2017 with “ !! “ = 2000
2017 with “ !!!!! “ = 2017.0
2.017 with “ !! “ = 2.0The formula should absolutely truncate the resulting number such that future calculations only use the digits displayed. Whether the number formats truly truncate or just alter what is displayed (while leaving the original value alone) I will leave to brighter minds.
I would also like to see the outlined options dynamically enabled. By this I mean:
round A1 to match the significant digits of cell A2, preferably without having to resort to some LEN formula.Something like SIGFIG(A1, A2) or SIGFIG(2017, A2)
Mike supported this idea · 
70 votes13 comments · Excel for Windows (Desktop Application) » Charting, Mapping and Visualizations · Flag idea as inappropriate… · Admin →
This is great feedback. We are looking into the details of this. Please continue to vote on feature ideas which will increase their likelihood of getting in the product.
Thanks,
Scott [MSFT]An error occurred while saving the comment Mike commentedThis would also alleviate the super silly 5/6th rule!
An error occurred while saving the comment Mike commentedExcel charts definitely needs to have a native scroll, scale and zoom feature. Every chart should be able to scale down from all points to x number of points, zoom in and out (which is slightly different than scaling), and scroll along both the x and y axis.
This would make the entire chart experience so much better!
Currently I have to build super complex and memory intensive double dynamic index formulas to pull this off, which only serves to stall out excel for up to a few minutes. if such features were native, my charts would be much more user friendly.
Mike supported this idea · 
14 votes6 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →Mike supported this idea ·
An error occurred while saving the comment Mike commentedThere are three ways to handle this, as a formula, as a number format category and as a custom number format. I think that all three are necessary and easy.
The formula would work just like ROUND but truncate to number of significant digits rather than just number of digits. Notice the trailing zeros, they are important.
SIGFIG(2017, 2) = 2000
SIGFIG(2.017, 2) = 2.0
SIGFIG(0.2017, 2) = 0.20The number format would operate like the Number, Currency, Accounting, and Percentage categories, with a simple selector to determine the number of digits.
The custom number format should look something like: “ !! “ to round to 2 significant figures and “ !!!!! “ to round to 5 significant figures. It would not matter if the number was an integer or a decimal.
2017 with “ !! “ = 2000
2017 with “ !!!!! “ = 2017.0
2.017 with “ !! “ = 2.0The formula should absolutely truncate the resulting number such that future calculations only use the digits displayed. Whether the number formats truly truncate or just alter what is displayed (while leaving the original value alone) I will leave to brighter minds.
I would also like to see the outlined options dynamically enabled. By this I mean:
round A1 to match the significant digits of cell A2, preferably without having to resort to some LEN formula.Something like SIGFIG(A1, A2) or SIGFIG(2017, A2)

1,181 votes126 comments · Excel for Windows (Desktop Application) » Charting, Mapping and Visualizations · Flag idea as inappropriate… · Admin →
Thank you for taking the time to share your request for linking min/max values of a chart axis to the cell value! We think this suggestion has merit; however, we don’t expect to devote time to it in the near future. We will continue tracking votes and comments here, and will keep this suggestion under consideration for future development.
Thank you again, and please keep sharing your thoughts!
Auston [MSFT]Mike supported this idea ·
I've not seen anything in over two years, despite multiple threads and a comprehensive solution framework (see below).
I would also like to see the outlined options dynamically enabled. By this I mean:
round A1 to match the significant digits of cell A2, preferably without having to resort to some LEN formula.
Something like SIGFIG(A1, A2) or SIGFIG(2017, A2)