ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Numerical problems... (https://www.excelbanter.com/excel-worksheet-functions/90415-numerical-problems.html)

Mr. Boyer

Numerical problems...
 
If I copy and paste an equation I have in Word to Excel, when I hit enter
instead of giving me a value the whole equation is crammed into the cell. Is
this because it is from Word or is the equation most likely missing something?

Peo Sjoblom

Numerical problems...
 
You probably copy over a text format as well or spaces, click in the formula
bar and paste in there and make sure there are no leading/trailing spaces



Regards,

Peo Sjoblom


"Mr. Boyer" wrote:

If I copy and paste an equation I have in Word to Excel, when I hit enter
instead of giving me a value the whole equation is crammed into the cell. Is
this because it is from Word or is the equation most likely missing something?



All times are GMT +1. The time now is 09:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com