Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

If I enter 123456, it should be displayed as 1.23456. However, the value stored internally should still be 123456.

Is this possible in Excel? Thanks for your time.

share|improve this question

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)

share|improve this answer
+1. Thanks. Is it also possible to display only 2 digits after the '.'? Like 1.23? – Gowtham Mar 9 '12 at 16:21
you want to have a custom display and trim the number in the same cell as the original number? No, I don't think that's possible. I can do that in a new column though, but not with the original data. – Raystafarian Mar 9 '12 at 16:51

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .