If I enter
123456, it should be displayed as
1.23456. However, the value stored internally should still be
Is this possible in Excel? Thanks for your time.
right click the cell and go to format, then down to custom format and enter:
This will change the display format with a "decimal" after the first digit, but it won't change the value of the contents of the cell (as seen in the formula bar)