Excel 2007 - Inputting Dates

  Alan2 14:17 28 Nov 2011

I have just upgraded from WinXP to Win7 and after reinstalling Office 2007 one key [for me] facility does not now seem to be available.

I like to input dates in Excel thus 28.11.11 but want the cell to show 28 Nov 2011. The regional settings in Win7 allow any format but I haven't yet found a way to get what I want. Spaces work as do slashes but I don't consider them to be as convenient as points (periods or full stops).

WinXP did have such a facility in regional setting but it has either been deleted or is just well hidden in Win7.

  Alan2 15:55 28 Nov 2011

Hi Woolwell, I can get the cells dispayed OK it's inputting using dd.mm.yy I want to be recognised.

Excel is happy if I input with dd/mm/yy or dd mm yy the display is what I want - ie dd mmm yyyy


  TonyV 16:01 28 Nov 2011


I think what Alan2 is looking for is to insert the date as 28.11.11 and get the formatted date as 28 Nov 2011. i.e. short date format. I don't think in 2007 and Win 7 the input as 28.11.11 can be done, because it thinks it is text!

I reckon the best way is to use the 28/11/11 as the input style. Beyond that, once the cells have been formatted to 28 Nov 2011, you could use crtl and ; to get today's date entered in a cell.


  TonyV 16:02 28 Nov 2011


We crossed posts!


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

Elsewhere on IDG sites

EE is the UK's first 5G network, launching next week

Philips 499P9H monitor review – this 49-inch screen turns heads and will make your colleagues…

MacBook Pro Buying Guide: 13in vs 15in MacBook Pro

Test : casque audio Avanti C de Moshi