J Julieanne Jan 14, 2010 #1 What is the formula to have Excel automatically enter the decimal so all I have to enter is the numbers?
What is the formula to have Excel automatically enter the decimal so all I have to enter is the numbers?
F Fred Smith Jan 14, 2010 #2 It's one of the options you can specify. In Excel 2007, it's: Excel Options...>Advanced>Automatically insert a decimal point Regards, Fred
It's one of the options you can specify. In Excel 2007, it's: Excel Options...>Advanced>Automatically insert a decimal point Regards, Fred