Putting numbers in excel without it changing into a formula?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!!!!!!
 
Go to Format>Cell>Number>what ever format you want.
Sounds like your cells are formatted as dates.
 
If you are inputting fractions, format the cells as ' ?/?@ without the
quotes.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

putting number against certain words formula 0
Excel formula 2
assigning values to one cell which will change the formula in anot 1
TROUBLE COPYING AND PASTING FORMULAS 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
IF AND Nested Functions - Formula Not Working 0
How to subtract a number from a Mergefield? 0
Formula: How do I create a "rolling" sum in excel? 7

Back
Top