System Separator in Excel 2007

Recently, I had problem in Excel 2007. The problem was related about System Separator and pasting number. When user try to paste number format from the page in browser, the result show like picture below:

Source: Number format in page at browser

ScreenShot225

Destination: Excel 2007

ScreenShot226

Actually there is no error show, but if you want to summarize or calculate the cells it’s gonna show error because it can’t be calculated. Why? Because the type of cells isn’t number, but text.

So, how to paste numbering format directly into similar format—nothing change at Excel, especially Excel 2007. The Answer is using System Separator—Decimal separator & Thousand separator.

All you have to do is go to the Excel Options then choose Advance. At the tab System Separator, switch the value of Decimal separator & Thousand separator.

ScreenShot228

If you configure correctly, the result gonna show like this.

ScreenShot229

Finally you can calculated the cells.

Leave a Reply

Your email address will not be published. Required fields are marked *

Hi there, welcome to my personal blog. Hope you enjoy visiting here. If you’d like to get in touch with me for either commercial and training purpose, feel free to reach my contact page. Cheers!