View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
M Thran M Thran is offline
external usenet poster
 
Posts: 1
Default Date extraction from data pull

Hi,
I have a data pull that gives me current month historical records. The data
received will always be yesterday going back by day to the beginning of the
current month. So, today's data would be from yesterday to the first. The
date pulled comes to me in the following format
01€*
02€*
03€*
04€*
05€*
06€*
07€*
08€*
09€*
10€*
11€*
12€*
This refers to the day of the current month. I would like ideas how I might
convert this to display as a regular date format in another cell (beside it)
mm/dd/yyyy
Each day the list increases by one number, at the bottom of the list.
Does anyone have any suggestions?
--
Mike Thran