VBA/Macros Course (40% Discount): [ Ссылка ]


Excel Quickie Playlist: [ Ссылка ]
Excel File: [ Ссылка ]

3 ways to convert scientific notation to regular numbers in order to show their full amount; this method also allows you to retain the appearance of text in case you have a mixed list of text and numbers in scientific notation format.

There are a number of ways to do this and what you should use depends on your dataset.

Additional Resources
Scientific Notation (Microsoft): [ Ссылка ]

Excel Courses:
- VBA/Macro Course: [ Ссылка ]
- Building Professional Forms: [ Ссылка ]
- Email Course: [ Ссылка ]

TeachExcel.com

#msexcel #excelquickie #tutorial

свернуть