how do i stop excel from turning a number into a date?

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

Guest

I'm entering a list of values which includes age bandings, eg 0-2, 3-7, 8-12.
Excel wants to turn the last two into dates ie 3 Jul and 8 Dec. How do i stop
this?
 
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 Convert word into numbers and back 4
Transposing 0
Excel Converting rows into each individual reports 0
excel won't sort dates correctly 0
How to export table from outlook into ms access table? 0
How can I stop Excel from autoformatting entries into a date 1
How to turn a number range into a date 2
How do I stop Excel from auto-inserting a date? 1

Back
Top