Quantcast

A community for students. Sign up today!

Here's the question you clicked on:

55 members online
  • 0 replying
  • 0 viewing

MathSofiya

  • 2 years ago

I'm having trouble with everything today..sigh I'm trying to type 6-11 into an Excel cell and it keeps changing that to June 11

  • This Question is Closed
  1. Libniz
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    because it is formatted as date , remove it

  2. MathSofiya
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 1

    how?

  3. MathSofiya
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 1

    <---illiterate

  4. Libniz
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    right click that cell

  5. MathSofiya
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 1

    and then?

  6. Libniz
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    tell me what shows up?

  7. MathSofiya
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 1

    format cell insert function hyperlink

  8. Libniz
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    go to format cell

  9. MathSofiya
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 1

    and then?

  10. MathSofiya
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 1

    just gives me font options and effects

  11. Libniz
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    bunch of tabs should show up

  12. MathSofiya
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 1

    yes

  13. MathSofiya
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 1

    should I get rid of the d-mmm

  14. MathSofiya
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 1

    I think that's what's giving me the date

  15. bloodrain
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 1

    you find it out yet?

  16. MathSofiya
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 1

    let me check if it worked

  17. bloodrain
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 1

    @MathSofiya

  18. bloodrain
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 1

    what version of excel u have?

  19. MathSofiya
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 1

    14.2.3 2011 for mac

  20. bloodrain
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 1

    OK, I have 2012 but i think its the same just a moment

  21. bloodrain
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 1

    hm, just a moment what exactly are you trying to do?

  22. Libniz
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    did you get rid of date format?

  23. MathSofiya
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 1

    I'm trying to write my class limits for my frequency table (statistics) which I have as 0-5 6-11 12-17 18-23 24-29

  24. bloodrain
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 1

    ok i found a workaround, does your keyboard have a number pad?

  25. MathSofiya
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 1

    No

  26. bloodrain
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 1

    what kind of computer is it? a macbook?

  27. MathSofiya
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 1

    Air

  28. Libniz
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    change format from date to number

  29. MathSofiya
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 1

    how?

  30. Libniz
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    it should have push button saying currency date number etc...

  31. MathSofiya
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 1

    yes I see that

  32. MathSofiya
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 1

    =(

  33. bloodrain
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 1

    ok @MathSofiya copy the character BETWEEN the quotes " " it looks like a space but if you paste it before the numbers they won't turn into a date!

  34. bloodrain
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 1

    did it work?

  35. MathSofiya
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 1

    I'm sorry...which quotes?

  36. bloodrain
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 1

    the quote marks after the word quotes =^.^=

  37. MathSofiya
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 1

    where in excel?...sorry I feel soo silly

  38. MathSofiya
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 1

    I'm laughing out loud now...I is this a foreign language to me?

  39. bloodrain
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 1

    OK before you type the numbers, type the invisible character " " <-- between these quotes (select between them and copy)

  40. MathSofiya
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 1

    I GOT IT! YAAAAY!!!!!

  41. MathSofiya
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 1

    Thank you sir!

  42. bloodrain
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 1

    hooray!

  43. MathSofiya
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 1

    31 mins LOL....Hey, I can only get less computer illiterate from here on

  44. Not the answer you are looking for?
    Search for more explanations.

    Search OpenStudy
    • Attachments:

Ask your own question

Ask a Question
Find more explanations on OpenStudy

Your question is ready. Sign up for free to start getting answers.

spraguer (Moderator)
5 → View Detailed Profile

is replying to Can someone tell me what button the professor is hitting...

23

  • Teamwork 19 Teammate
  • Problem Solving 19 Hero
  • You have blocked this person.
  • ✔ You're a fan Checking fan status...

Thanks for being so helpful in mathematics. If you are getting quality help, make sure you spread the word about OpenStudy.

This is the testimonial you wrote.
You haven't written a testimonial for Owlfred.