| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if function checking for numerical data vs alpha characters | Excel Worksheet Functions | |||
| Does True Have a Numerical Value | Excel Worksheet Functions | |||
| Return Numerical Label for LAST value Subtracted to reach Sum Target Value | Excel Worksheet Functions | |||
| Return Range of Numerical Values in Single Column based on Frequency Percentage | Excel Worksheet Functions | |||
| Numerical grade to Alpha character | Excel Discussion (Misc queries) | |||
Linear Mode
