Ask Your Question

How to get a cell to read as a number

asked 2018-06-06 18:42:51 +0200

saby gravatar image

When I copy and paste my cell reads as #value. How to make my formula read as a number.

edit retag flag offensive close merge delete


i didn't understand your question. please explain your problem in details

kompilainenn gravatar imagekompilainenn ( 2018-06-06 20:02:56 +0200 )edit

Do you need to paste the formula or just want to paste the number?

Xoristzatziki gravatar imageXoristzatziki ( 2018-06-07 18:18:38 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-06-06 21:53:38 +0200

hjek gravatar image

Perhaps you copied and pasted a formula with relative references, and in the cell you pasted it in, those relative references point to invalid values?

If you only want to copy and paste the value of a cell only, then instead of using normal Paste, you should use Paste Unformattxed Text (Shift Ctrl Alt V).

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-06-06 18:42:51 +0200

Seen: 32 times

Last updated: Jun 06 '18