Excel 2007 decimal point

[srizki]

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

 

[sr12345]

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]

If you mean select format cell, then no, it is not working. I have tried all formats already.

 

[swinglow]

File Ribbon > Options > Advanced > Automatically insert a decimal point

should be right near the top of the list

 

[srizki]

I got that i was looking for Option, to change it, i found out,
Thanks.