Microsoft Office Forums - View Single Post - [Solved] Date formating problem in EXCEL 2003

Thread: [Solved] Date formating problem in EXCEL 2003

View Single Post

Old

01-05-2012, 10:06 AM

lyngio

lyngio is offline

lyngio uses Windows XP

Windows XP lyngio uses Office 2003

lyngio uses Office 2003

Office 2003

Novice

The original poster

Join Date: Jan 2012

Posts: 6

lyngio is on a distinguished road

Default

Quote:

Originally Posted by Pecoflyer

View Post

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

Reply With Quote