0

I am importing(copy-paste) values into Excel from R Console which are in scientific notation (1.920943e-10, 7.580894e-05). Excel is not treating them as numbers instead text. How to resolve this ?

Thanks

Edit: The problem is with the entire workbook. I'm not able to paste the image as it needs min of 10 reputation.

1
  • Could you add more info on specifically how you are importing the values?
    – Some_Guy
    Jul 7, 2015 at 8:15

1 Answer 1

0

When you enter then cell with the value stored is there a visible leading apostrophe? like this:

'1.920943e-10

If so, delete it.

If not, try right click>format cells> choose a number format

Finally an option that will work if all else fails is to put in a second column in your sheet. Where

A1= 1.920943e-10

A2 should be
=value(A1)

Should do the trick no problem.

If you don't want that column in your end sheet, the select it, copy, and paste special>paste as values.

This will paste the value of the formula and you can delete the source infomation (i.e. column 1) and just keep the converted data (column 2)

4
  • Thanks for the suggestions. I have tried them but didn't work out !
    – Prradep
    Jul 7, 2015 at 8:33
  • what happened with =value(A1)?
    – Some_Guy
    Jul 7, 2015 at 8:45
  • i have got the error #VALUE!
    – Prradep
    Jul 7, 2015 at 8:47
  • OK, can you take a screen shot with the cell with a problem number in it highlighted?
    – Some_Guy
    Jul 7, 2015 at 8:53

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .