Posted to microsoft.public.excel.misc

Daniel L. Lieberman Daniel L. Lieberman is offline

external usenet poster

Posts: 11

Date Entry

Excel 2007, Vista Business, US English.

I was able to use Ctrl+; with cells formatted dd/mmm in Excel 2003 and the
result was e.go. 14/May.

Now with similar cell formatting I get 14/5/2007 when I use the Ctrl+;

Does anyone know what is going on?
TIA

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Restricting date entry relative to current date	bwalshjr	Excel Worksheet Functions	1	April 10th 07 12:49 PM
Date entry	excel-duh?[_2_]	Excel Discussion (Misc queries)	3	April 7th 07 11:08 PM
date entry	Mags	Excel Discussion (Misc queries)	2	January 25th 07 12:26 AM
last entry of a particular date	shaji	Excel Discussion (Misc queries)	1	July 29th 06 03:54 PM
Date entry	magstate	Excel Discussion (Misc queries)	2	March 23rd 05 07:15 PM

All times are GMT +1. The time now is 12:30 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us