Probs with dates in cells

  steviegee 09:07 20 Jun 2007

I have to enter a lot of dates in cells on a spreadsheet. The problem I have is when I enter 02/01 it changes to Jan-07 (in the formula bar it says 02/01/2007)! I want it to say Feb-01. It also happens when I enter 03/03 it changes to Mar-07 (in the formula bar it says 03/03/2007) instead of Mar-03. Whats happening!!!??

  VoG II 09:12 20 Jun 2007

Select the cells that you will be entering dates in. Format > Cells > Number tab, select Date in the left hand pane and in the right hand pane click on 'Mar-98' (or similar) and click OK.

  steviegee 09:19 20 Jun 2007

That hasn't worked. I must add anything before 2000 works ok e.g 10/94 comes up as it should Oct-94. Its anything 00 on

  VoG II 09:25 20 Jun 2007

Try a custom format dd-mmm

  steviegee 09:48 20 Jun 2007

No good, I have about 5000 rows which need to be in the same format so I need to highlight the column so they are all the same.

  johnnyrocker 09:49 20 Jun 2007

so why dont you?


  steviegee 09:51 20 Jun 2007

Because it isn't working correctl, read the previous posts.

  VoG II 09:52 20 Jun 2007

Are you using Excel? If so, which version?

  steviegee 09:59 20 Jun 2007

Yes, 2003.

  VoG II 10:02 20 Jun 2007

I'm using Excel at present and formatting a column as I suggested works for me. I cannot understand why this would not work in Excel 2003, sorry.

  VoG II 10:02 20 Jun 2007

Oops - using Excel 2000.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Honor 9 Lite review

How Social Media has Propelled Political Graphic Design and Art in the Last Decade

The best kids apps for iPhone & iPad 2018

HomePod d’Apple : date de sortie, prix et fiche technique