<div>
Your method worked. I just need to remember to do this again on cell H16 if I enter a new formula.<br />
<br />
Thank you.<br />
<br />
Conernesto
</div>


Your method worked. I just need to remember to do this again on cell H16 if I enter a new formula.

Thank you.

Conernesto

<div>
<div class="content wysiwyg-content">
I have an Excel workbook. I am using a lot of columns and entering formulas. On cell H16 I entered a formula =F2. The result I see in cell H16 is &quot;=F2&quot; instead of the value that is on cell F2. Do you know how I can fix this so I can copy the formula across the same row? &nbsp;Currently the format of cell H16 is Text.
</div>
</div>


I have an Excel workbook. I am using a lot of columns and entering formulas. On cell H16 I entered a formula =F2. The result I see in cell H16 is "=F2" instead of the value that is on cell F2. Do you know how I can fix this so I can copy the formula across the same row?  Currently the format of cell H16 is Text.

Excel formula not working do to cell format

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.