Date formating problem in EXCEL 2003

		Microsoft Office Forums > Microsoft Excel > Excel
Date formating problem in EXCEL 2003

01-05-2012, 10:06 AM

lyngio

Windows XP Date formating problem in EXCEL 2003

Office 2003

Novice

Join Date: Jan 2012

Posts: 6

Quote:

Originally Posted by Pecoflyer

If you enter 40912 in a cell and format as dd-mmm, what happens?

Your underlying value is 41000 which is April 1st

By enetring 40912 in the cell I get 01-Apr

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
word 2003 date picker	nashville	Word	16	04-06-2012 04:12 AM
Problem with opening xlsm in excel 2003	cryjoh	Excel	2	12-13-2011 11:49 AM
Excel 2003 / 2007 files saving slow on Win 2003 Server	Atradius	Office	0	07-23-2011 07:41 AM
Excel 07 formating 17 cells "Need Formula"	Raner	Excel	2	05-30-2010 02:07 PM
Excel Date Alert?	Kelleigh	Excel	1	12-05-2008 09:35 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:39 AM.