numbers

  • Thread starter Thread starter Kristen
  • Start date Start date
K

Kristen

when i enter 1-1 it keeps going to the date I'd rather it not do that how do
i stop it?
 
Enter this as '1-1 into a cell which will format that as text..

If this post helps click Yes
 
If you have similar information to be entered into an entire column; select
the column..Right click..Format Cells..as Text before you start entering the
data//
 
hi
perhaps you forgot to mention that you can preceed the input with an
apostrophe and accomplich the same thing.

regards
FSt1
 
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

Text not date 4
Working With Dates in Excel 2
Access Dateadd function question.. 0
Formatting time 6
Auto date in excell 2010 4
Auto Cell Format Change from General to Custom Date 1
Date format in cell 3
Time Values As Numbers 3

Back
Top