Page 1 of 3 123 LastLast
Results 1 to 15 of 34
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Excel-lent Puzzle

    Without touching the keyboard, how can you get the value in cell A1 to change to the value 1 <img src=/S/question.gif border=0 alt=question width=15 height=15>
    Regards,
    Rudi

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Excel-lent Puzzle

    <span style="background-color: #FFFF00; color: #FFFF00; font-weight: bold">Highlight the .25
    right-click - cut,
    change to another location</span hide>

    Steve

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Excel-lent Puzzle

    <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>
    I never considered that one. You are quite right, BUT thats not the method I had in mind!
    I'm after another method!
    Regards,
    Rudi

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Excel-lent Puzzle

    <span style="background-color: #FFFF00; color: #FFFF00; font-weight: bold">You can select the "1" and edit - copy
    select another cell
    then go back to the cell and edit - paste</span hide>

    Steve

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel-lent Puzzle

    Here is a cumbersome method:

    <span style="background-color: #FFFF00; color: #FFFF00; font-weight: bold">Select Format | Cells...
    Specify Number format with 0 decimals (you can use the spinner buttons to do this with the mouse)
    Click OK
    Select Tools | Options...
    Activate the Calculation tab.
    Tick the check box 'Precision as displayed'.
    Click OK (twice).
    The value in A1 will change to 1.
    If you wish, you can now reset the format to General and turn off 'Precision as displayed'.</span hide>

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Excel-lent Puzzle

    Another method:
    <span style="background-color: #FFFF00; color: #FFFF00; font-weight: bold">Format cells - number - 0 decimal
    [note: this does not change the value on the display]
    to change the value:
    tools - options - calc (tab) check: precision as displayed
    acknowledge the warning
    then turn back the option
    tools - options - calc (tab) - uncheck -precision as displayed
    Warning: this may affect more than just this cell</span hide>

    Steve

  7. #7
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Excel-lent Puzzle

    I suppose you can...it works! BUT... still not the method I am after.
    Darn Steve... you are proving my little puzzle toooooo solvable.

    OK - besides both of Steve's methods ... how else can you make 1.25 = 1 without touching the keyboard <img src=/S/question.gif border=0 alt=question width=15 height=15>
    Regards,
    Rudi

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel-lent Puzzle

    Great minds... <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>

  9. #9
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Excel-lent Puzzle

    You beat me to this one!

    Personally I don't like it since it may affect other cells, all to avoid just pressing the "1" on the keyboard. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Steve

  10. #10
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Excel-lent Puzzle

    Good try Hans and Steve...that may work, and yes it is a possible answer, BUT...not recommended!

    Try again!
    Regards,
    Rudi

  11. #11
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Excel-lent Puzzle

    PS...
    It's not a valid answer to say: "Cover the .25 on the monitor with your finger!!!"
    Regards,
    Rudi

  12. #12
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel-lent Puzzle

    So the puzzle is not "how to get 1 into cell A1 without touching the keyboard", but "what exactly did Rudi have in mind when he posted it".

    <span style="background-color: #FFFF00; color: #FFFF00; font-weight: bold">Install speech recognition software and tell Excel to change the value of cell A1 to 1.</span hide>

  13. #13
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Excel-lent Puzzle

    <span style="background-color: #FFFF00; color: #FFFF00; font-weight: bold">Select A1
    Data - text to columns
    Fixed width - <next>
    add line to the right of the "1"
    <Next>
    Select teh second column and press "Skip"
    <finish></span hide>

    Steve

  14. #14
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Excel-lent Puzzle

    <hr>So the puzzle is not "how to get 1 into cell A1 without touching the keyboard", but "what exactly did Rudi have in mind when he posted it".<hr>

    Yes this does seem to be the problem (and this "type of problem") is becoming more frequent on the board. What ever happened to question with 1 answer or being correct if the answer is valid?

    Maybe I will start posing some of my own... <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>

    Steve

  15. #15
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Excel-lent Puzzle

    <span style="background-color: #FFFF00; color: #FFFF00; font-weight: bold">Have a friend push the "1" on your keyboard.</span hide>

    Steve

Page 1 of 3 123 LastLast

Posting Permissions

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