srizki Well-known Member Joined Jan 14, 2003 Messages 1,791 Office Version 3652016 Platform Windows Jun 22, 2010 #1 I am using excel 2007 and it is set to two decimal points. So when I type 1 or 2 or 3 etc. it comes as 0.01, 0.02, 0.03. where is option window. Thanks
I am using excel 2007 and it is set to two decimal points. So when I type 1 or 2 or 3 etc. it comes as 0.01, 0.02, 0.03. where is option window. Thanks
S sr12345 Active Member Joined Feb 20, 2009 Messages 317 Jun 22, 2010 #2 Right-click the cell, select format number, number, and then select the number of decimal places you want. Use format painter brush to copy this format to other cells/the entire worksheet. Never mind. Last edited: Jun 22, 2010
Right-click the cell, select format number, number, and then select the number of decimal places you want. Use format painter brush to copy this format to other cells/the entire worksheet. Never mind.
srizki Well-known Member Joined Jan 14, 2003 Messages 1,791 Office Version 3652016 Platform Windows Jun 22, 2010 #3 If you mean select format cell, then no, it is not working. I have tried all formats already.
S swinglow Active Member Joined Mar 31, 2010 Messages 394 Jun 22, 2010 #4 File Ribbon > Options > Advanced > Automatically insert a decimal point should be right near the top of the list
File Ribbon > Options > Advanced > Automatically insert a decimal point should be right near the top of the list
srizki Well-known Member Joined Jan 14, 2003 Messages 1,791 Office Version 3652016 Platform Windows Jun 22, 2010 #5 I got that i was looking for Option, to change it, i found out, Thanks.