Putting numbers in excel without it changing into a formula?

R

RachaelDPT

I am trying to set up an excel spreadsheet and it is automatically changing
all my numbers into dates. Ahhh I just want my data values, no formuals
needed. Help please, I'm getting frustrated!!!!!!!
 
H

Hugh

Go to Format>Cell>Number>what ever format you want.
Sounds like your cells are formatted as dates.
 
B

Bob Phillips

If you are inputting fractions, format the cells as ' ?/?@ without the
quotes.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top