Usually when working with large numbers it is useful to see the comma separator to be able to more clearly read the numbers.
I was recently asked how to get rid of the commas. If you want to remove the comma separators, on the Home tab , in the Number group, click the dialog box launcher. The Format Cells dialog box will be displayed, with the Number tab uppermost. In the Category secion, click Number.
Remove the tick from Use 1000 Separator. Click OK. The commas will disappear.
Find out more about our Excel training courses Sydney, Australia.