Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-27-2012, 03:37 AM
lyngio lyngio is offline Date formating problem in EXCEL 2003 Windows XP Date formating problem in EXCEL 2003 Office 2003
Novice
Date formating problem in EXCEL 2003
 
Join Date: Jan 2012
Posts: 6
lyngio is on a distinguished road
Thumbs up

Quote:
Originally Posted by macropod View Post
Hi lyngio,

The culprit is your 'Worksheet_Change' macro. Change:
Target(1).Value = UCase(Target(1).Value)
to:


If Not IsDate(Target) Then Target(1).Value = UCase(Target(1).Value)
Sorry it's taken a while for me to get back but I've been on holidays...
Anyways, Fantastic........Works a treat now!!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date formating problem in EXCEL 2003 word 2003 date picker nashville Word 16 04-06-2012 04:12 AM
Date formating problem in EXCEL 2003 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
Date formating problem in EXCEL 2003 Excel 07 formating 17 cells "Need Formula" Raner Excel 2 05-30-2010 02:07 PM
Date formating problem in EXCEL 2003 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 06:34 PM.


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