Go to the Tools menu, choose Options, then the Edit tab. There,
check the "Fixed decimal" option and enter 2 for the number of
places.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"jacsells" wrote in message
...
how do i get the decimal point to enter automatic when i enter
123 and i want
1.23 without entering the decimal point manualy?