Thursday, February 25, 2016

Troubleshooting:Equation Comes in as Text

Equation Comes in as Text

Hi All,
I don't know what is wrong but the worksheet has some existing formulae/equations but when i try to add another, it comes in as text.
All i want is for the value of cell D1 to appear in N24 so i enter "=D1" (without the quotes) in N24 but it just comes in as text.
Please help me understand what i'm sure is a basic blunder.

Solutions to the Problem Equation Comes in as Text

Download SmartPCFixer for Free Now

...and that quickly, i figured it out.
The cell into which i was trying to enter the equation was formatted as "text" which is the same formatting as the cell whose value i wanted to repeat, but it appears the format MUST be "General" to accept an equation.
Any comments?

If you failed to fix it, another option is to call Microsoft and walk through the process with a technician. To do this, dial "1-800-936-5700". Explain the error that you received and the steps in the update process during which it was displayed. The technician will be able to walk through the steps from getting a new product key to finishing the installation.

Another Safe way to Fix the Problem: Equation Comes in as Text:



How to Fix Equation Comes in as Text with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your system.  Open it, and it will scan your computer. The junk files will be shown in the scan result.

2. After the scan is finished, you can see the errors and problems which need to be repaired.

3. When the Fixing part is done, your computer has been speeded up and the errors have been removed

Related: Black hole Gap in Task Bar Windows 8 1 Pro asus drivers Getting Error code 0x80070015 when doing backup in Windows 7 asus mainboard driver download Metro Apps Still Not Lauching After April 8 Windows 8 1 Update asus motherboard drivers Silverlight Updates causing Windows 7 32bit system to hang at desktop asus support Starting in Oct 2012 My computer started shuting down at radom times I sometimes get a error box saying Microsoft Windows is not responding asus com System Restore vs Windows Backup asus drivers Windows Unexpected Shutdowns Need Help asus support Steps to One-Click Download and Update Asus Touchpad Drivers on Your Computer,Icon Deleted Nd Required,Computer After Infected By Fake Antivirus,Resource (web Proxy) Is Online But Isn't Responding To Connection Attempts,Using Drop.down Box In Word,Win 7 X64 32gb SDHC ReadyBoost Issue
Read More: How to Resolve - Having trouble with easy file transfer from,Host Process stopped working. Vista based system,Windows 7 64 Bit: Programs won't close (i.e. will stay in background for several minutes until they disappear and can be reopened again). This is true for Internet Explorer but other programs as well, including WMP.,[Solved] Extra Space in Paragraph after inserting text box\/image,How to Fix Error - Challenge-Combining multiple worksheets to create master database to run a pivot?,Application Does Not Start in Windows 7,NTLDR is Missing. Press CTR + ALT + DEL to restart?,Apps keep crashing every time I click on the tile, what's wrong?,Why is windows experience index for graphics score is less than gaming graphics score?,MSE keeps detecting and quarantining trojan js/medfos.b, how to remove it permanently?

No comments:

Post a Comment