EXCEL FEED: [ExcelVBA] Off Topic: TRIM or a different function as part of loop

Kamis, 18 April 2013

[ExcelVBA] Off Topic: TRIM or a different function as part of loop

I have a column in Excel that is formatted by default as a date with the following format m/d/yyyy h:mm:ss AM/PM
The problem I'm having is sometimes the value getting imported does not have the h:mm:ss part of the date so Excel displays it as number as text. When I check the actual value in the cell I notice there are 3 null values after the date number.

If I click in the cell with a date number and hit enter Excel recognizes the date number and converts it into a date and life is sweet again.

What kind of loop can I use to have VBA check the cell and if needed convert the date number as text into date while leaving the cells that are already displayed correctly as is?

Thanks,

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Recent Activity:

New Members 4

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

MARKETPLACE