Thread: Change format of date when using Now function in VB code
View Single Post
 
Old 03-02-2012, 05:09 PM
JBeaucaire JBeaucaire is offline Windows XP Office 2003
Advanced Beginner
  
Join Date: Dec 2011
Posts: 51
JBeaucaire is on a distinguished road
Default
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?
Reply With Quote