anonymous
  • anonymous
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
Mathematics
  • Stacey Warren - Expert brainly.com
Hey! We 've verified this expert answer for you, click below to unlock the details :)
SOLVED
At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis praesentium voluptatum deleniti atque corrupti quos dolores et quas molestias excepturi sint occaecati cupiditate non provident, similique sunt in culpa qui officia deserunt mollitia animi, id est laborum et dolorum fuga. Et harum quidem rerum facilis est et expedita distinctio. Nam libero tempore, cum soluta nobis est eligendi optio cumque nihil impedit quo minus id quod maxime placeat facere possimus, omnis voluptas assumenda est, omnis dolor repellendus. Itaque earum rerum hic tenetur a sapiente delectus, ut aut reiciendis voluptatibus maiores alias consequatur aut perferendis doloribus asperiores repellat.
katieb
  • katieb
I got my questions answered at brainly.com in under 10 minutes. Go to brainly.com now for free help!
anonymous
  • anonymous
because it is formatted as date , remove it
anonymous
  • anonymous
how?
anonymous
  • anonymous
<---illiterate

Looking for something else?

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

More answers

anonymous
  • anonymous
right click that cell
anonymous
  • anonymous
and then?
anonymous
  • anonymous
tell me what shows up?
anonymous
  • anonymous
format cell insert function hyperlink
anonymous
  • anonymous
go to format cell
anonymous
  • anonymous
and then?
anonymous
  • anonymous
just gives me font options and effects
anonymous
  • anonymous
bunch of tabs should show up
anonymous
  • anonymous
yes
anonymous
  • anonymous
should I get rid of the d-mmm
anonymous
  • anonymous
I think that's what's giving me the date
anonymous
  • anonymous
you find it out yet?
anonymous
  • anonymous
let me check if it worked
anonymous
  • anonymous
@MathSofiya
anonymous
  • anonymous
what version of excel u have?
anonymous
  • anonymous
14.2.3 2011 for mac
anonymous
  • anonymous
OK, I have 2012 but i think its the same just a moment
anonymous
  • anonymous
hm, just a moment what exactly are you trying to do?
anonymous
  • anonymous
did you get rid of date format?
anonymous
  • anonymous
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
anonymous
  • anonymous
ok i found a workaround, does your keyboard have a number pad?
anonymous
  • anonymous
No
anonymous
  • anonymous
what kind of computer is it? a macbook?
anonymous
  • anonymous
Air
anonymous
  • anonymous
change format from date to number
anonymous
  • anonymous
how?
anonymous
  • anonymous
it should have push button saying currency date number etc...
anonymous
  • anonymous
yes I see that
anonymous
  • anonymous
=(
anonymous
  • anonymous
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!
anonymous
  • anonymous
did it work?
anonymous
  • anonymous
I'm sorry...which quotes?
anonymous
  • anonymous
the quote marks after the word quotes =^.^=
anonymous
  • anonymous
where in excel?...sorry I feel soo silly
anonymous
  • anonymous
I'm laughing out loud now...I is this a foreign language to me?
anonymous
  • anonymous
OK before you type the numbers, type the invisible character " " <-- between these quotes (select between them and copy)
anonymous
  • anonymous
I GOT IT! YAAAAY!!!!!
anonymous
  • anonymous
Thank you sir!
anonymous
  • anonymous
hooray!
anonymous
  • anonymous
31 mins LOL....Hey, I can only get less computer illiterate from here on

Looking for something else?

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