I am a new user to excel 2007, upgrading from Excel 2003. When I format a large number to insert a comma for the thousands it does not work as I would expect. i.e if it is a 4 digit number it does ok ....e.g. 1234 becomes 1,234. However if it is a larger 7 digit number it does not put in the second comma i.e. 1234567 becomes 1234,567. How can I make it place a comma between the "1" and the "2" as any other program would do. FYI I am doing this by: format cells, number, and checking the box for 'use 1000 separator'
version that you have. Please do not take offence if I ask you to try a very simple task. In Cell A1 please type in 1234567. Then click any other cell. Now go back to Cell A1 and click on it. While Cell A1 is now alive click on the comma button in the Numbers tab on the Home Ribbon. You should now have 1,234,567.00 in Cell A1. As in my previous post, click on the decrease decimal button on the same Numbers tab - click it twice to get rid of the two decimal places. It should work for you!