Excel Formatting
 

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?????
--
Cyndi

Excel Formatting
 

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

"Cyndi" wrote:

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?????
--
Cyndi