Question

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

Answer 1

because it is formatted as date , remove it

Answer 2

how?

Answer 3

<---illiterate

Answer 4

right click that cell

Answer 5

and then?

Answer 6

tell me what shows up?

Answer 7

format cell
insert function
hyperlink

Answer 8

go to format cell

Answer 9

and then?

Answer 10

just gives me font options and effects

Answer 11

bunch of tabs should show up

Answer 12

yes

Answer 13

should I get rid of the d-mmm

Answer 14

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

Answer 15

you find it out yet?

Answer 16

let me check if it worked

Answer 17

@MathSofiya

Answer 18

what version of excel u have?

Answer 19

14.2.3 2011 for mac

Answer 20

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

Answer 21

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

Answer 22

did you get rid of date format?

Answer 23

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

Answer 24

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

Answer 25

No

Answer 26

what kind of computer is it? a macbook?

Answer 27

Air

Answer 28

change format from date to number

Answer 29

how?

Answer 30

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

Answer 31

yes I see that

Answer 32

=(

Answer 33

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!

Answer 34

did it work?

Answer 35

I'm sorry...which quotes?

Answer 36

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

Answer 37

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

Answer 38

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

Answer 39

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

Answer 40

I GOT IT! YAAAAY!!!!!

Answer 41

Thank you sir!

Answer 42

hooray!

Answer 43

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