Excel Trick: Avoid Scientific Notation for Long Numbers
Excel Trick: Avoid Scientific Notation for Long Numbers
When you type long numbers into Excel the program turns them into scientific notation and it will even round off the end of the number dropping excess digits. If you need to type a really long number into Excel here is a method to do so.
VIEW MORE VIDEOS JUST LIKE THIS ON MY YOUTUBE CHANNEL
Microsoft Office ► / @mastermicrosoftoffice
TIP ME TO SAY THANK YOU? ► paypal.me/projectwoman
VISIT PROJECTWOMAN.COM FOR MORE ON MICROSOFT OFFICE APPLICATIONS:
Website ► http://www.projectwoman.com
Blog ► http://www.projectwoman.com/blogger
IF YOU LIKED THIS VIDEO YOU MAY LIKE THESE SIMILAR VIDEOS:
Excel Quickly Adjust Row Heights - Auto Resize or Manual ► • Excel Quickly Adjust Row Heights - Auto Re...
Excel Navigate Worksheet Tabs in Big Workbooks - Quick & Easy ► • Excel View All Worksheet Tabs in Big Workb...
Excel Insert Column as you Move Data - Automatically Make Room for Data ► • Excel Auto-Add Column as you Move Data - M...
Excel Stop Printing Empty Pages - Solve Print Problems with Page Break Preview ► • Excel Stop Printing Empty Pages - Solve Pr...
Excel Trick: Avoid Scientific Notation for Long Numbers ► • Excel Trick: Avoid Scientific Notation for...
Excel Remove Table Filter Buttons - Clean Up a Table ► • Excel Remove Table Filter Buttons - Clean ...
Excel Button Navigation - Quick & Easy Macro Free Solution ► • Excel Button Navigation - Quick & Easy Mac...
Excel hack: Uppercase to Proper Case in Seconds ► • Excel hack: Uppercase to Proper Case in Se...
One Keystroke to Jump to Last Filled Row in Excel ► • One Keystroke to Jump to Last Filled Row i...
Excel Formula for the Last Value in a Column ► • Excel Formula for the Last Value in a Colu...
Excel trick: Split Data into Columns Without Typing ► • Excel trick: Split Data into Columns Witho...
Excel Hack: Enter Data in Multiple Cells Instantly ► • Excel Hack: Enter Data in Multiple Cells I...
Autofill Like a Pro: Excel Data Filling Tip ► • Autofill Like a Pro: Excel Data Filling Ti...
Zero Clutter - Hide Zeros in Excel Sheets ► • Zero Clutter - Hide Zeros in Excel Sheets ...
Excel Loan Calculations Made Easy ► • Excel Loan Calculations Made Easy #shorts
Excel Magic - Hide Data in Plain Sight ► • Excel Magic - Hide Data in Plain Sight #sh...
Excel Data Fusion - Join Columns in Seconds! ► • Excel Data Fusion - Join Columns in Second...
Excel Hack: Sort Names Like a Pro ► • Excel Hack: Sort Names Like a Pro #shorts
Ultimate Age Calculation Hack in Excel ► • Ultimate Age Calculation Hack in Excel #sh...
Excel Date Picker Magic: Save Time with a Clickable Calendar ► • Excel Date Picker Magic: Save Time with a ...
Reverse Bar Chart Plotting Order in a Snap! Excel Quick Tip ► • Reverse Bar Chart Plotting Order in a Snap...
What to do when Increase Decimals Doesn't Work in Excel ► • What to do when Increase Decimals Doesn't ...
Word don’t spell check selected text ► • Word Hacks: Prevent Spell Check on Specifi...
Stop the Frustration: How to Paste Data with Column Widths in Excel ► • Stop the Frustration: Paste Data with Colu...
From Chaos to Order: Reverse an Unsorted List in Excel ► • From Chaos to Order: Reverse an Unsorted L...
Excel Chart Flip 101: Flip a Plot from Right to Left ► • Excel Chart Flip 101: Flip a Plot from Rig...
Fix First Column for Always Visible Row Headings ► • Fix First Column for Always Visible Row He...
Create Perfect Square Grids in Excel in Seconds! ► • Create Perfect Square Grids in Excel in Se...
Excel Screen Cleanup: Hide Annoying On-Screen Page Breaks ► • Excel Screen Cleanup: Hide Annoying Dotted...
Excel Mastery: Create JPG from Range without Leaving Excel! ► • Excel Mastery: Create JPG from Range witho...
Make Each Chart Bar Pop with a Different Color in Excel! ► • Make Each Column or Bar a Different Color ...
Chart Aesthetics 101: Customize Legend Text in Excel ► • Chart Aesthetics 101: Customize Legend Tex...
From Default to Custom: Edit Labels & Descriptions in Excel Pivot Tables ► • From Default to Custom: Edit Labels & Desc...
Excel Magic: Preventing Format Changes in PivotTables ► • Excel Magic: Preventing Format Changes in ...
Chart Inside Cells: Create Excel Data Bars Quickly & Easily ► • Chart Inside Cells: Create Excel Data Bars...
Help My Chart Disappeared When I Hid a Column! ► • Help My Chart Disappeared When I Hid a Col...
Excel Pro Tip: Convert Formulas to Numbers ► • Excel Pro Tip: Convert Formulas to Numbers...
#helenbradley #microsoftexcel #microsoftoffice #projectwoman #ExcelShorts #Excelforstudents #excelforbeginners #excelformulaforjobinterview