Easiest way would be to go to ToolsOptionsEdit and checkmark "fixed deimal
places" and set to 2.

Otherwise divide 1234 by 100 after the fact.

Enter 100 in an empty cell then Copy that cell.

Select the other cell with 1234 and Paste SpecialDivideOKEsc.

Others have posted that you can change 1234 into 12.34 by formatting.

You would still have 1234 as a value no matter how you format it.


Gord Dibben Excel MVP

On Fri, 18 Feb 2005 10:30:16 -0600, shlomo
wrote:


How do make that when I enter 1234 its should come out 12.34