xcel Number Formatting Problem

[andyp161]

Hi there,

I have exported accounting information from a company data website int
excel. For some reason, where profit figures had a 1000 seperator (,
on the website, when exported into excel the 1000 seperator became
decimal point (.). Also, the profit figures taken from the website ar
in GDP th i.e. excluding the last '000'.

Therefore, please can you help me do the following:

1) Replace the unwanted decimal point (.) back to a 1000 seperato
(,).
2) Add 000 to the end of the profit figures so that they are in writte
in full.

Many thanks

And

 

[Jerry W. Lewis]

The separators that Excel uses for thousands and for decimal points are
controlled by regional settings.

Copy 1000, select the region of numbers that exclude the last 000 and
Edit|Paste Special|Multiply.

Jerry