Excel 2007 - Inputting Dates

  Alan2 14:17 28 Nov 2011
Locked

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.

  Woolwell 15:06 28 Nov 2011

I do this through Excel itself. When you type 28/11/11 in the cell then I find it automatically converts to 28/11/20111. However to get what you want then on the hone ribbon click on the small arrow bottom right of number and choose custom. In the type box put dd mmm yyyy. If you highlight a whol column by clicking n the top before setting the format all of that colum will be in that format.

  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

Alan2

  TonyV 16:01 28 Nov 2011

Woolwell

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

  TonyV 16:02 28 Nov 2011

Alan2

We crossed posts!

TonyV

  Woolwell 16:07 28 Nov 2011

I suspect that you need a macro.

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

Elsewhere on IDG sites

Fujitsu Lifebook P727 laptop review

Microsoft Paint set to die after 32 years

Mac power user tips and hidden tricks

Comment désactiver la saisie intuitive et paramétrer votre clavier ?