![]() |
make excel automatically add a decimal
Is there a way to make Excel automatically add a decimal two places from the
right, like you can program calculator to do? Darrell |
make excel automatically add a decimal
Click on Tools | Options | Edit tab, then check Fixed Decimal.
You might like to change it back when you are done. Hope this helps. Pete On Mar 20, 5:22*pm, "Darrell Eddy" wrote: Is there a way to make Excel automatically add a decimal two places from the right, like you can program calculator to do? Darrell |
All times are GMT +1. The time now is 06:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com