Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date extraction
I have a macro set up that pulls out the dates from my information.
I am not sure but I think what I have below is the spot that defines the date format to pull out my dates from my data. If I put 2/2/10 it does not pull out the date. If I put 02 it does pull out the date. Is there a way so it will pull it out whether I put 2 or 02 for the month? Selection.NumberFormat = "m/d/yy;@" Thank You |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date extraction
Selection.NumberFormat = "m/d/yy;@" simply formats the date to Text
Can you post the entire macro? Gord Dibben MS Excel MVP On Tue, 2 Feb 2010 16:21:01 -0800, Donna wrote: I have a macro set up that pulls out the dates from my information. I am not sure but I think what I have below is the spot that defines the date format to pull out my dates from my data. If I put 2/2/10 it does not pull out the date. If I put 02 it does pull out the date. Is there a way so it will pull it out whether I put 2 or 02 for the month? Selection.NumberFormat = "m/d/yy;@" Thank You |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extraction | Excel Worksheet Functions | |||
Date extraction from data pull | Excel Discussion (Misc queries) | |||
Extraction | Excel Discussion (Misc queries) | |||
extraction | Excel Discussion (Misc queries) | |||
Extraction | Excel Worksheet Functions |