Will excel 2003 format a cell to the year?

  • Thread starter Thread starter kateofmd
  • Start date Start date
K

kateofmd

It seems like it should be obvious, but I am finding it impossible to
get excel to do a date format that recognizes a year. Is there some
way?
 
I typed a date in A1 (09/28/2006)
and used format|Cells|number tab|custom category|yyyy

with my USA settings.
 
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

Editing conditional formats (Excel 2010) 15
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Sum all items from the given year 7
Data exported to excel 2007 changes cell number format to 'general' ? 1
How to convert decimal year to date format in excel 2
Excel Default Date Format When Not Including The Year In The Entry 2
excel does not recognize dates 2
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1

Back
Top