Date Text
I want to concatenate a date to a string value, but I want to see a formatted date, like 03/20/2013, not 42399. To do this, create a text representation of the dates. Add a column next to the date column and set the formula for
=TEXT(D2, "mm/dd/yyyy")
This will convert the date in D2 to a text representation of the date. (They will probably look the same to the human eye, but the computers sees them differently. Use the value in the TEXT column to concatenate to your string.
03/20/2014 1:00 am Link ID: 03202014-66
Worksheet Functions
There are several useful worksheet functions. See the articles on these functions:
Sum Product
Sum If
CountA
VLookup
Watch for new articles on additional
Excel Functions in the near future.
03/17/2014 2:15 pm Link ID: 03172014-114
Excel VBA Samples
Programming Excel with VBA requires an understanding of the object model.
This screen shows an image of the
Excel Object Model.
The model has many more elements than are shown here, but these are the main objects.
The
Workbook Object and
Worksheet Object are the containers for all other Excel Objects.
Understanding how to reference them in code is essential for programming Excel.
The
Excel Range is the most important and versatile object.
This article shows basic functions with a range object, such as Copy/Paste, Move and Name.
A Future article will examine the
Excel Range Object in depth.
When running an Excel macro, we often have to select which file or files to process.
The
Open File article shows how to have an OpenFile dialog
box appear. The
Read Folder article shows how to read through
all the files in a given folder. The files can be filtered by various criteria. There is also
an article on how to
Save a file after processing.
03/17/2014 1:45 pm Link ID: 03172014-6