Custom Number Format

If you’re working with data in Google Sheets you’ll soon come across a time when you will need to clean and format phone number data entries. To clean phone numbers …

When you start entering text into a cell and the first character of that cell is a plus symbol (+) you will get an error #NAME? and you would have …

Do you need to compress those large numbers in your spreadsheet down by representing them as thousands, or millions? This simple custom formatting technique will help you clean up your numbers real quick!