Formatting Problem

  • Thread starter Thread starter MET
  • Start date Start date
M

MET

I want to format a column to not automatically convert the numbers I'm
entering into a date. I highlight the column and click on "format cells".
On the Number tab I click on General which states "General format cells have
no specific number format" and then I click on OK. This is what I think I
want. But when I enter "12-14" in one of the cells, it converts it to
"14-Dec".
 
You have 2 choices. Format the cell as TEXT prior to entering 12-14 or enter
the 12-14 as '12-14. The apostrophe makes what follows it text. The General
format means basically text will be left justified and numbers will be right
justified.

Tyro
 
Thanks, Tyro! Formatting the cells as Text solved my problem and I will try
to keep your other tip in mind for future use.
 

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

Conditional formatting in Excel 2010 2
Remove date format? 3
number changing 4
Overlapping Cells 4
Format Issue 4
Date changes to 0-Jan-00 when I leave cell 10
format time problem 5
Numbers showing Up Centered in Cell ? 1

Back
Top