|
Excel Tips
|
Conversions
Converting from number to date - If you
have a cell with a numeric value like 6152006 (June 15, 2006) and
you need handle it like a date, create a new column that converts
the numeric value to a character, then substring out the Month, Day,
and Year and use in the Date function
You can convert it all in one step like this -
Change date format from MM/DD/YYYY to YYYYMMDD - If you
have character dates containing slashes, but you want to treat it
like a number in Excel, try this -
=CONCATENATE(LEFT(A2,2),MID(A2,4,2),RIGHT(A2,2))
To
get a date in Excel and format it as character data, try this
=TEXT(YEAR(D8),"0000") & TEXT(MONTH(D8),"00") &
TEXT(DAY(D8),"00")
Last Updated
12/21/2006 11:47 AM | |  |
