Change format of date when using Now function in VB code

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Change format of date when using Now function in VB code

FAQ

Thread Tools

Display Modes

03-02-2012, 05:09 PM

JBeaucaire JBeaucaire is offline

Windows XP Change format of date when using Now function in VB code

Office 2003

Advanced Beginner

Join Date: Dec 2011

Posts: 51

Since I only see you putting some text and timestamps in column T, why don't you simply format that column for the DATE/TIME format you want. Once you've done that, putting TEXT in that cell won't cause a problem, and when a timestamp is added back in it will already be the correct format.

Or is there other code somewhere that is replacing the formatting of cells in that column?

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA code to change	carlleese24	Excel Programming	2	08-13-2011 09:48 AM
Today's Date Function	freschij	Excel	3	02-11-2011 10:21 AM
Automatic Date Function Corrupting Printer Output	Theodulf	Word	0	05-28-2010 12:33 PM
Date Function in word?	aligahk06	Word	1	04-21-2010 06:33 AM
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:38 PM.