A community for students.
Here's the question you clicked on:
 0 viewing
MathSofiya
 3 years ago
I'm having trouble with everything today..sigh
I'm trying to type 611 into an Excel cell and it keeps changing that to June 11
MathSofiya
 3 years ago
I'm having trouble with everything today..sigh I'm trying to type 611 into an Excel cell and it keeps changing that to June 11

This Question is Closed

Libniz
 3 years ago
Best ResponseYou've already chosen the best response.0because it is formatted as date , remove it

MathSofiya
 3 years ago
Best ResponseYou've already chosen the best response.1format cell insert function hyperlink

MathSofiya
 3 years ago
Best ResponseYou've already chosen the best response.1just gives me font options and effects

Libniz
 3 years ago
Best ResponseYou've already chosen the best response.0bunch of tabs should show up

MathSofiya
 3 years ago
Best ResponseYou've already chosen the best response.1should I get rid of the dmmm

MathSofiya
 3 years ago
Best ResponseYou've already chosen the best response.1I think that's what's giving me the date

MathSofiya
 3 years ago
Best ResponseYou've already chosen the best response.1let me check if it worked

bloodrain
 3 years ago
Best ResponseYou've already chosen the best response.1what version of excel u have?

bloodrain
 3 years ago
Best ResponseYou've already chosen the best response.1OK, I have 2012 but i think its the same just a moment

bloodrain
 3 years ago
Best ResponseYou've already chosen the best response.1hm, just a moment what exactly are you trying to do?

Libniz
 3 years ago
Best ResponseYou've already chosen the best response.0did you get rid of date format?

MathSofiya
 3 years ago
Best ResponseYou've already chosen the best response.1I'm trying to write my class limits for my frequency table (statistics) which I have as 05 611 1217 1823 2429

bloodrain
 3 years ago
Best ResponseYou've already chosen the best response.1ok i found a workaround, does your keyboard have a number pad?

bloodrain
 3 years ago
Best ResponseYou've already chosen the best response.1what kind of computer is it? a macbook?

Libniz
 3 years ago
Best ResponseYou've already chosen the best response.0change format from date to number

Libniz
 3 years ago
Best ResponseYou've already chosen the best response.0it should have push button saying currency date number etc...

bloodrain
 3 years ago
Best ResponseYou've already chosen the best response.1ok @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!

MathSofiya
 3 years ago
Best ResponseYou've already chosen the best response.1I'm sorry...which quotes?

bloodrain
 3 years ago
Best ResponseYou've already chosen the best response.1the quote marks after the word quotes =^.^=

MathSofiya
 3 years ago
Best ResponseYou've already chosen the best response.1where in excel?...sorry I feel soo silly

MathSofiya
 3 years ago
Best ResponseYou've already chosen the best response.1I'm laughing out loud now...I is this a foreign language to me?

bloodrain
 3 years ago
Best ResponseYou've already chosen the best response.1OK before you type the numbers, type the invisible character " " < between these quotes (select between them and copy)

MathSofiya
 3 years ago
Best ResponseYou've already chosen the best response.1I GOT IT! YAAAAY!!!!!

MathSofiya
 3 years ago
Best ResponseYou've already chosen the best response.131 mins LOL....Hey, I can only get less computer illiterate from here on
Ask your own question
Sign UpFind 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
 Engagement 19 Mad Hatter
 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.