Changing Text To Numbers ?

B

Bob

Hello,

Using Excel 2007.

Copied a list of "numbers" from a site.
They all "look like" numbers, e.g., 23.456.

Excel is apparently interpreting this as text, when I Paste what I
copied into it.

It appears on the left hand side of the cell.
I guess that this means that it thinks it is Text.
True ?

I tried re-formatting these copied cells as Numbers in Excel, but they
still appear on the left hand side of the cells.

What do I have to do to have Excel handle these as numbers, and not as
text ?

Thanks,
Bob
 
C

Claus Busch

Hi Bob,

Am Sun, 03 Mar 2013 10:15:06 -0500 schrieb Bob:
I tried re-formatting these copied cells as Numbers in Excel, but they
still appear on the left hand side of the cells.

select your column with the numbers, format as numbers and then Data =>
TextToColumns => Fixed width => Finish


Regards
Claus Busch
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top