Microsoft excel help, please! D:

Discussion in 'General Chat' started by sweetpea, Feb 19, 2008.

  1. #1
    Does anyone know how i can mask the "value" of a cell in Microsoft Excel? Say the cell (B2)'s value is 0.29, i want the cell to say "Korea".. ? And when the cell in question is used in a code such as "=B2*4.3", B2 will be 0.29 and not Korea.

    Am i making sense? D: And does anyone have any idea? I have to figure this out in five minutes' time. I'm broke at the moment and can't offer any money, but agh... um sig advertising? :p And uh.. green rep?
     
    sweetpea, Feb 19, 2008 IP
  2. mark123456

    mark123456 Peon

    Messages:
    786
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    0
    #2
    just shrink the column sizes to .1 pixels or whatever and then PDF the document so that whoever you are showing it to can't see your numbers.
     
    mark123456, Feb 19, 2008 IP
  3. Dondon2d

    Dondon2d Peon

    Messages:
    3,193
    Likes Received:
    146
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Uhh, I don't think that is possible without VB coding. You must use macros or whatever they call it. Lol.
     
    Dondon2d, Feb 19, 2008 IP
  4. elgourmet

    elgourmet Guest

    Messages:
    55
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    check this site. i'm sure you will find an answer there:
    excelforum.com
     
    elgourmet, Feb 19, 2008 IP