Microsoft Office Forums - View Single Post - [Solved] Excel 2010 - Converting fractions into dates

Thread: [Solved] Excel 2010 - Converting fractions into dates

View Single Post

Old

04-05-2011, 09:00 AM

judicial85 judicial85 is offline

judicial85 is offline

judicial85 uses Windows 7

Windows 7

judicial85 uses Office 2010 (Version 14.0)

Office 2010 (Version 14.0)

Advanced Beginner

The original poster

Join Date: Nov 2010

Posts: 64

judicial85 is on a distinguished road

Default

Excel 2010 - Converting fractions into dates

Hello,

I would love to know where in Excel Options (2010) I can tell the program to stop changing "1/3" into "01-Mar". I import (copy/paste) a lot of tables with fractions and they are never intended for dates.

Any help would be much appreciated. Thanks,

Bryan

Reply With Quote