Date formating problem in EXCEL 2003

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

FAQ

Thread Tools

Display Modes

01-05-2012, 10:02 AM

Pecoflyer

Windows XP Date formating problem in EXCEL 2003

Office 2003

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,943

Pecoflyer has a reputation beyond repute

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

Your underlying value is 41000 which is April 1st

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« Previous Thread | Next Thread »

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 08:41 AM.