Date formating problem in EXCEL 2003

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

FAQ

Thread Tools

Display Modes

01-27-2012, 03:37 AM

lyngio

Windows XP Date formating problem in EXCEL 2003

Office 2003

Novice

Join Date: Jan 2012

Posts: 6

Quote:

Originally Posted by macropod

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!!

« 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 04:28 AM.