Another Question!!

  • Thread starter Thread starter Tricia LeAnn
  • Start date Start date
T

Tricia LeAnn

I'm also typing in 3/4 and it is automatically changing to Mar 4... HELP?!?
 
You can format the cell as Text before entering in any data. This will
prevent Excel from changing what looks like a date to a date. If you enter
=3/4 you'll get 0.75 in the cell.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2008
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
Excel interprets 3/4 as 3/4/2008. If you want a fraction you must enter: 0
3/4

Tyro
 
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

Excel Help with dates 2
Fomula help needed 2
Formual help needing using multiple criteria 10
how to force excel not to change date? 2
Calculate time difference 1
Help with formating 2
Making Oxygen on Mars 4
Locating a specific cell 1

Back
Top