Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Date formatting Date formatting
Register FAQ Mark Forums Read

Reply
 
Thread Tools Display Modes
  #1  
Old 08-14-2011, 06:39 AM
Catalin.B Catalin.B is offline Date formatting Windows Vista Date formatting Office 2007
Expert
  
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default
since the AD column in the sheet "typed " cannot be formatted to compare it to a date, the only thing i can advice you to do is to change column AD data in which date is entered correctly, to a piece of text that can be compared to the text in typed sheet: in an empty column, say AF, enter this formula: =TEXT(AD1;"mmm-yy"); copy this formula down to your row range; then click on column letter AF to select the entire column AF , click on AD1, and paste only values( paste special- only values). In this moment, AD1 column can be compared... look at sample attached..
Hope this fits you
Attached Files
File Type: xlsx Converted version.xlsx (33.9 KB, 9 views)
Reply With Quote
  #2  
Old 08-14-2011, 07:38 AM
kjxavier kjxavier is offline Date formatting Windows XP Date formatting Office 2007
Advanced Beginner
Date formatting 		 
Join Date: Jul 2011
Posts: 39
kjxavier is on a distinguished road
Default Date Formatting
Quote:
Originally Posted by Catalin.B View Post
since the AD column in the sheet "typed " cannot be formatted to compare it to a date, the only thing i can advice you to do is to change column AD data in which date is entered correctly, to a piece of text that can be compared to the text in typed sheet: in an empty column, say AF, enter this formula: =TEXT(AD1;"mmm-yy"); copy this formula down to your row range; then click on column letter AF to select the entire column AF , click on AD1, and paste only values( paste special- only values). In this moment, AD1 column can be compared... look at sample attached..
Hope this fits you
Yes Catalin..... its works......... dat's enough for me......
Thanks a lot...... .......
Reply With Quote
  #3  
Old 08-15-2011, 02:52 AM
Catalin.B Catalin.B is offline Date formatting Windows Vista Date formatting Office 2007
Expert
  
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default
You're welcome
Reply With Quote
  #4  
Old 08-23-2011, 07:59 AM
kjxavier kjxavier is offline Date formatting Windows XP Date formatting Office 2007
Advanced Beginner
Date formatting 		 
Join Date: Jul 2011
Posts: 39
kjxavier is on a distinguished road
Default Ctrl+d function
Hi!

can i disable Ctrl+d function in Excel?
Reply With Quote
  #5  
Old 08-23-2011, 08:21 AM
Catalin.B Catalin.B is offline Date formatting Windows Vista Date formatting Office 2007
Expert
  
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default
you can do this search too...

http://www.mrexcel.com/forum/showthread.php?t=36014
Reply With Quote
Reply

Tags
formatting

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Hybrid Mode Hybrid Mode


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date formatting Date formatting kjxavier Excel 6 08-12-2011 05:46 AM
Date formatting Date Formatting in MS word 2007 Karthick Word 4 01-19-2010 05:54 AM
Date formatting Inserting Date, formatting to superscript and subscript louq Word 1 10-22-2009 09:29 AM
new appointment date always reverts back to today's date msills Outlook 0 08-24-2007 08:57 AM
Date formatting Imported message date change to today's date promark Outlook 1 12-23-2005 07:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:41 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft