Edmonton Business Consulting

adviser, mentor, counselor, expert, specialist, professional, authority, commercial, occupational, corporate, professional,

  • BLOG
  • WHAT WE DO
    • Business Intelligence Reporting
    • Business Consulting
    • Project Management
    • ERP Consulting
    • Software Implementations
    • Business Plans
  • WHO WE ARE
  • OUR PROCESS
  • CONNECT
Home > Formula Showing in Excel Instead of Value

Formula Showing in Excel Instead of Value

December 16, 2014 by Matt Miciula Leave a Comment

What to do when your Formula is Showing in Excel Instead of Value

1. worksheet is set to display formula and not results. Hold down the CTRL and tap `

2. Double check the cell value to see if a quote or character exists before the formula “=A1”. The correct formula is =A76 note there are no quotes.

3. Ensure the cell is formatted as text. Select the cell, right click, format cells and select ‘general’. Now tap F2 and enter.

Filed Under: Excel Tagged With: Formula, Microsoft, Value

Leave a Reply Cancel reply

You must be logged in to post a comment.

Recent Posts

  • View CRA Account Balance and Activities
  • Microsoft SQL Server View to Excel
  • Fixing Lease Amortization from Lease Complete Conversion
  • Lease Asset Update from Conversion
  • Web PostgreSQL to Excel PowerPivot

About Ascend

About Ascend Management Consultants

Ascend Management Consultants was started to bring the focus of consulting back to providing exceptional customer service that builds long-term relationships. Our goal is to become a strategic partner and to help you achieve superior … More

Find More

Project Management

Free 1 Hour Meeting

Contact us to find out how Ascend Management Consultants can assist you with your business intelligence reporting and ERP system needs. We can arrange an introductory meeting.

Company Profile

Ascend Management Consultants is an Edmonton based business consulting firm specializing in management solutions and business intelligence for mid-market organizations.

Navigate

  • BLOG
  • WHAT WE DO
    • Business Intelligence Reporting
    • Business Consulting
    • Project Management
    • ERP Consulting
    • Software Implementations
    • Business Plans
  • WHO WE ARE
  • OUR PROCESS
  • CONNECT

Recent Updates

View CRA Account Balance and Activities

Microsoft SQL Server View to Excel

Fixing Lease Amortization from Lease Complete Conversion

Lease Asset Update from Conversion

Web PostgreSQL to Excel PowerPivot

Formula Showing in Excel Instead of Value

Connection Settings RDP Windows 8

© Copyright 2015 Ascend Management Consultants · All Rights Reserved · Powered by Edmonton SEO Company