+ Reply to Thread
Results 1 to 6 of 6

Auto convert formula to text

  1. #1
    Registered User
    Join Date
    09-26-2008
    Location
    Iran
    Posts
    9

    Auto convert formula to text

    hi
    how can I write a formula in a cell that after calculate convert to text, without VBA!

  2. #2
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    Hi,

    welcome to the forum, you can display formula's by using keyboard shortcut/toggle Ctrl+`
    oldchippy
    -------------


    Blessed are those who can give without remembering and take without forgetting

    If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

  3. #3
    Registered User
    Join Date
    09-26-2008
    Location
    Iran
    Posts
    9
    tanx! but I need an auto way to do it without using VBA (if possible!)

  4. #4
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    Don't think you can do that without VBA?

  5. #5
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Maybe

    Ctrl + H > Find box enter
    =
    and replace box enter
    '=
    then replace all

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  6. #6
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    Of course you can Tools >Options > Formulas

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. activation or validation a cell text formula
    By VBNewbie in forum Excel General
    Replies: 4
    Last Post: 04-29-2008, 06:06 AM
  2. How to make a formula from a text string?
    By Helsinghof in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-28-2007, 09:07 AM
  3. Convert Formula To Plain Text
    By tomyknoker in forum Excel General
    Replies: 3
    Last Post: 11-15-2007, 08:18 AM
  4. Writing Text and Formula in the formula bar of a cell
    By modest_16081982 in forum Excel General
    Replies: 2
    Last Post: 08-27-2007, 05:25 AM
  5. Replies: 3
    Last Post: 08-23-2007, 04:47 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1