Is there a number format that I can use that will display numbers in the thousands without actually using a formula? So, 20,000,000 in sales in a cell would actually be displayed as 20,000.
Good question, and yes there is.
The number format
#,##0, works because of the comma at the end.