i typed in something (8-18) and it converted it to a date (Aug-18)
how do i turn this off?
CER
cermiestarkitten
right click on the cell, the go down to format cells. a window should come up click on the bit on the top that says number then from the toolba on the left selet general....should work
FIR
FireSenior Member
hmm I never thought you'd know that cermie 🙂
CER
cermiestarkitten
there are many things about me you don't know....😈
FIR
FireSenior Member
*runs away*
CER
cermiestarkitten
what? why? 😇
YER
yerssotSenior Member
👆 cerm, the computer nerd
CER
cermiestarkitten
yep...that's me 😉
YER
yerssotSenior Member
*makes L-sign*
CER
cermiestarkitten
*cries*
YER
yerssotSenior Member
😖, I aimed it at mah! really! *covers cerm with hugs* 🙁
CER
cermiestarkitten
really? at mah?
YER
yerssotSenior Member
I would never even think of aiming it at you, miss!
CER
cermiestarkitten
aw *hugs* yay!
TEX
TexYumsz
In Excell just use ---> ' <--- before you type something and it will remain as a character.
YER
yerssotSenior Member
you're too nice for that 😉
BUR
burlymanhonky
i did what you said cerm and it didnt work, thanks tex that worked 😛