Formating Decimal values

Right click the area with numbers and go to Format Cells, Number, Custom, and use the following: #.00

You would see that behavior if the "numbers" were previously formatted as Text. Changing the format to something numeric won't convert the text to numbers. Consequently, the formatting change will not be visible. You need to convert the text to numbers.
Try this:
• Select your single-column range of "numbers"
• Data.Text-to-columns...Click: Finish

Does that solve the problem?

@DAVYBOY

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

Originally Posted by davyboy

none of these worked for me when I copied a table from web and pasted to Excel. What works sometimes is to paste with formatting as text, then apply one of these conversions mentioned above. Sometimes it does not work. What gives?

Frequently, when we copy from a web page, some whitespace that looks like regular spaces are actually nonbreaking spaces (HTML nbsp).

Usually, it is sufficient to paste into Notepad (or equivalent) first, then copy from Notepad and paste into Excel.

Alternatively, if your pasted data is in A1:A100, enter the following formula into a parallel column and copy down:

=--TRIM(SUBSTITUTE(A1,CHAR(160),""))

The double-negate (--) converts numeric text into a numeric value. Any equivalent arithmetic operation will do the same; for example, multiply by 1 or add zero.