Excel Formatting

G

Guest

Hi. I'm having a very difficult time with this. I copied a table from a
website and pasted it into an Excel spreadsheet. Excel doesn't recognize the
numbers as numbers, but as text. Someone suggested that I use the VALUE
function to change the text to numbers. That's not working. Any other
ideas?????
 
G

Guest

Hi Cyndi

Some times Excel gets confused but if you multiply the cells by 1 this can
often change them into numbers that excel can uinderstand. So put the number
1 into a cell then copy it, then highlight the numbers and paste special
values and tick the multiply box.

You might also want to check that there are no extra spaces in the cells if
there are highlight the numbers and do a find " " and leave the replace blank.

Thanks

Paul
 

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

Similar Threads

Changing Text To Numbers ? 1
Format appears stuck..how to break formatting 2
Excel formatting 2
Cell formatting when pasting from a non-Office application 2
Removing text from a cell with text and numbers 2
How do I make cell references return to normal? 4
formatting when pasting into excel 1
Formatting cells copied from a website 4

Top