View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
marketerinco marketerinco is offline
external usenet poster
 
Posts: 12
Default Date won't format

Do I put that information into the custom field?

"David Biddulph" wrote:

Try Data/ Text to Columns/ Delimited/ Next/ Next/ Column Data Format: Date:
MDY/ Finish
Format your result appropriately.
--
David Biddulph

"marketerinco" wrote in message
...
I am trying to get a date column to apply a format. For example the dates
are entered as 1/22/2007 and I need them to be 01/22/2007 but when I go
into
dates and select that format it does not apply it. Does anyone know what
I
can do? These are expiration dates that we need to import into our eblast
program for membership renewals.