Making text appear in cell as written

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

Guest

I try to write a sports team's record in a cell, for example 5-3, but as soon
as I enter the text it will be converted to May 3 or to 5/3/2006. I cannot
imagine why this program assumes I am enetering a date. I am not.

I have tried to format the cell to 'general' so that the text appears as
written but this function does not prevent the transformation to a date.
 
Either format the cell as 'Text' or precede your text entry with a
single quote...

'5-3

Hope this helps!
 

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 Typed text appears in wrong cell 0
Comparison of columns using Conditional Formatting 3
SUM only Cells where there is text in Another cell 1
Cell interpreted as mailto 5
Macro:- Find first blank cell and write text 8
Convert number to text as displayed 3
Searching the formula (not the value) for a text string 1
want to track time while paste value in multiple column of same roe 1

Back
Top