+ Reply to Thread
Results 1 to 2 of 2

Turning off formulas

  1. 11-18-2017, 01:49 AM #1
    xcracer41
    xcracer41 is offline
    Registered User
    Join Date
    10-30-2017
    Location
    United States
    MS-Off Ver
    2016
    Posts
    20

    Turning off formulas

    I need to enter a value "-Ac" into a cell without it turning it into a formula
    Reply With QuoteRegister To Reply
  2. 11-18-2017, 02:05 AM #2
    leelnich
    leelnich is offline
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Turning off formulas

    Precede with an apostrophe '-Ac
    Clicking the Add Reputation star below helpful posts is a great way to show your appreciation.
    Please mark your threads as SOLVED upon conclusion (Thread Tools above Post # 1). - Lee
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Formulas turning into zeros when another user saves file
    By maddockd in forum Excel General
    Replies: 3
    Last Post: 05-11-2017, 11:48 AM
  2. Excel turning data into formulas
    By Sgsolberg in forum Excel General
    Replies: 6
    Last Post: 07-10-2015, 08:46 AM
  3. [SOLVED] Turning formulas into text?
    By Cmorgan in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 08-18-2013, 04:31 AM
  4. Turning cells used in summation formulas on or off...
    By cheiss8078 in forum Excel General
    Replies: 1
    Last Post: 10-05-2010, 03:06 PM
  5. Excel is turning entered dates into formulas despite format. Why?
    By Matt Mahan in forum Excel General
    Replies: 1
    Last Post: 04-12-2006, 12:50 PM
  6. Formulas in are turning into values for no reason
    By Steve in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-04-2006, 02:15 PM
  7. [SOLVED] Disabling formulas and turning file into text only
    By Christine in forum Excel General
    Replies: 3
    Last Post: 04-01-2005, 01:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1