Learn how to format numbers in Thousands, Millions, and Billions in Excel and Google Sheets. Use number Formatting to convert numbers.

If the numbers keep changing to dates in Microsoft Excel, you can use the following methods to fix the issue: Format cells as text. Insert an apostrophe before the number. Use Paste Special.

Excel has a surprising limitation that you may not discover until you try to enter more than 15 digits in a cell. The application can only store numbers with15 digits of precision.

The date will display in the format you choose, no matter how you enter it. If you type "1/1/19" into a cell with the long date format, Excel will change it to the expanded date.

When the Format Cells dialog box opens, it's automatically set to display Excel's numeric-data format options. Select a format category that matches your data type.