You tried a native Excel funtion called "text to column"?
In 99% of cases resolve quickly.
De: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] Em nome de
Manny
Enviada em: quinta-feira, 18 de abril de 2013 12:21
Para: ExcelVBA@yahoogroups.com
Assunto: [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,
[Non-text portions of this message have been removed]
Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
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
----------------------------------
Tidak ada komentar:
Posting Komentar