Penny Arcade Forums› Help / Advice Forum
The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
Please vote in the Forum Structure Poll. Polling will close at 2PM EST on January 21, 2025.

Simple Excel issue, I hope [SOLVED]

FunkyWaltDoggFunkyWaltDogg Columbia, SCRegistered User regular
edited November 2007 in Help / Advice Forum
If I open Excel and type "1 - 9" (no quotes), Excel will autocorrect it to 1/9/2007. If anyone can tell me how to force Excel to leave my data alone so that I don't have to punch my monitor in rage, I would appreciate it greatly.

FunkyWaltDogg on

Posts

  • FunkyWaltDoggFunkyWaltDogg Columbia, SCRegistered User regular
    edited November 2007
    Okay, I figured it out. You just have to format as text.

    FunkyWaltDogg on
  • xThanatoSxxThanatoSx Registered User regular
    edited November 2007
    If you want the cell to display is as "1-9" (w/o quotes), the you need to type the following into the cell:

    '1-9

    the ' tells excel not to look at the data for formula purposes.

    /or format as text - that works too. icon_mrgreen.gif

    xThanatoSx on
This discussion has been closed.
Penny Arcade Forums› Help / Advice Forum