Results 1 to 4 of 4

Thread: Cell value isnt what it is seen in the value

  1. #1

    Cell value isnt what it is seen in the value



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello. It is possible that i see in one cell the value 400 and the real value in the cell to be different? For example i want to see in the cell "400" but it s real value to be 300..thks

  2. #2
    You could store 400 in another cell and use the Camera tool to show that over the main cell's real value.

  3. #3
    Use the custom format "400" and apply to relevant cell(s).

  4. #4
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    772
    Articles
    0
    Excel Version
    2010
    Quote Originally Posted by Enigma View Post
    Use the custom format "400" and apply to relevant cell(s).
    Nice one!

Posting Permissions

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