Catherine this is to do with the cell format. In the cell in question, press: ctrl+1 this opens the format environment. press tab you will probably hear 'general' spoken. Cursor down till you hear 'date' - this may be preceded by an example. Tab again if you now cursor up and down you will hear the different formats of date spoken. HTH David In message <JEEFIJANMBCMGKOAJIPHMEJOIAAB.catherineturner2000@xxxxxxxxxxx >, Catherine Turner <catherineturner2000@xxxxxxxxxxx> writes >Hi, > >In an excel sheet someone's given me one of the cells has Dec-04 written it. >I wanted to edit it so I pressed f2, but then it says 01/12/04. How come it >says Dec-04 when just moving through the columns but when I press f2 it says >01/12/04? > >Catherine > >** To leave the list, click on the immediately-following link:- >** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe] >** If this link doesn't work then send a message to: >** access-uk-request@xxxxxxxxxxxxx >** and in the Subject line type >** unsubscribe >** For other list commands such as vacation mode, click on the >** immediately-following link:- >** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq] >** or send a message, to >** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq > -- David W Wood ** To leave the list, click on the immediately-following link:- ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe] ** If this link doesn't work then send a message to: ** access-uk-request@xxxxxxxxxxxxx ** and in the Subject line type ** unsubscribe ** For other list commands such as vacation mode, click on the ** immediately-following link:- ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq] ** or send a message, to ** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq