View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BMF BMF is offline
external usenet poster
 
Posts: 1
Default Limit character count in cell from left


This may have already been answered, but I'm going to ask it anyway : )

I work with the same spread sheet every day and I need to limit the
character count in one of the date cells. The text come in as:

200607120910
and I need it to take off the hour and minute of the time stamp:
20060712

Thanks in advance.


--
BMF
------------------------------------------------------------------------
BMF's Profile: http://www.excelforum.com/member.php...o&userid=36297
View this thread: http://www.excelforum.com/showthread...hreadid=560750