I am using version 15.13.1 running on the latest Mac OS 10.10. Obviously, with ID numbers, this problem makes things like vlookup impossible. I have opened a new workbook and am experiencing the problem in the workbook. I initially noticed it in a spreadsheet that I was working on this morning (btw - it did not do this last week). This problem makes things quite difficult. This means that I can not enter numbers in ExcelĪt all - I even tried to add $50 into a cell and it returns as being $0.01 (the number is 0.005, converted to 2 decimal places). In this guide, we’re going to show you how you can use Excel formula for filtering data. Excel has built-in features for this, an Excel formula for filtering data was not in the software's scope until the introduction of dynamic array functions. If I enter 1234, Excel 2016 changes this to 0.1234. Filtering data helps focusing on certain aspects of a data set. It also happens regardless of the number of digits that I enter. This happens whenever I enter the number in a cell, regardless of how the cell is formatted. Whole number, it has always remained a whole number (regardless of whether or not it is formatted as General, Text, Number etc.). I have never experienced this in the past.
When I enter the number, Excel has started adding a decimal place after the 4th digit, so I get 1234.5678. I have been trying to enter ID numbers in Excel which are 8 digits (in format 12345678).
