Learn four ways for formatting numbers in millions in Excel, including custom number formatting, using the TEXT function, the ROUNDUP function, and changing display units on a chart.| Spreadsheet Planet
Learn how to add leading zeros in Excel using various methods such as apostrophe, custom number formatting, and functions. Find out how to retain leading zeros and apply these methods to multiple cells.| Spreadsheet Planet
Learn how to quickly select every other cell in Excel using three ingenious tricks (using Go To special, Filter, and a VBA macro code)| Spreadsheet Planet
Learn three easy ways to fill blank cells with the value above in Excel (using 'Go To Special' with a formula, 'Find and Replace' with formula, or VBA)| Spreadsheet Planet
Learn how to format phone numbers in Excel for better readability and auto-formatting. Create custom number formats for international and local codes.| Spreadsheet Planet
Learn how to remove the dollar sign in Excel using different methods such as formatting, formulas, Find and Replace, and the VALUE function.| Spreadsheet Planet
Learn how to count negative numbers in Excel using COUNTIF formulas and a simple VBA macro code.| Spreadsheet Planet
Learn how to remove commas in Excel, whether from numbers or text strings. Use Find and Replace, formulas, or the Text to Columns wizard.| Spreadsheet Planet