|
|
|
|
|
|
|
|
Office
Question:Adding "user-defined fields", which would be a scenario where you would like to create a custom form or a standard form for contacts? It seems that either one may be designed for individual preferences. The custom form would have another "message class" but what would be the benefit of that. I know that this sounds like a hypothetical question and I do not want to take precious time on the...Read More
Posted: 21 Feb 2012
Tags:
Custom form Versus Standard form for contacts
Custom
form
Versus
Standard
for
contacts
|
|
|
|
|
|
|
|
Office
Question:Downloads have the system date is 2012-mm-dd hh: mm: ss General format. I need to convert to the format of date normal mm-dd-yy hh: mm: ss.Thank youAnswer:Select your cells and run this small macro:Sub ReFormat()Dim r As Range, v As StringFor each r in selectionv = r.Textyear = Left (v, 4)MN = Mid (v, 6, 2)dy = Mid (v, 9, 2)HR = Mid (v, 12, 2)Mint = Mid (v, 15, 2)SC = Right (v, 2)r.NumberFormat...Read More
Posted: 19 Feb 2012
Tags:
I have an excel file 10 with a column of date in format yyyymmdd hh mm ss I want to convert to the standard datetime format that is mmddyy hh mm ss
have
excel
file
with
column
date
format
yyyymmdd
want
convert
the
standard
datetime
that
mmddyy
|
|
|