Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 5th 05, 09:35 PM
Laura
 
Posts: n/a
Default How to format a date to a different format

I need help in converting a date "20050205" where the first 4 numbers are the
year, the 2nd two numbers are the month, and the last two would represent the
day of the month. I have tried several things to format these and looked in
Help but I am not asking the right question. I want to be able to have the
data read 02/05/2005 or something close such as 2/5/05. The date format it
is currently would be fine if that was the only report, but I have several
other downloads that I work with and those dates are in the format I am
requesting. Also the original format is hard to read if your not used to
it....... is there a solutions

Many thanks
--
Laura
Mfg Planning

  #2   Report Post  
Old March 5th 05, 09:59 PM
Myrna Larson
 
Posts: n/a
Default

Select the column with the dates, then Data/Text to Columns, and on the 3rd
screen select Date and the YMD option

On Sat, 5 Mar 2005 13:35:02 -0800, "Laura"
wrote:

I need help in converting a date "20050205" where the first 4 numbers are the
year, the 2nd two numbers are the month, and the last two would represent the
day of the month. I have tried several things to format these and looked in
Help but I am not asking the right question. I want to be able to have the
data read 02/05/2005 or something close such as 2/5/05. The date format it
is currently would be fine if that was the only report, but I have several
other downloads that I work with and those dates are in the format I am
requesting. Also the original format is hard to read if your not used to
it....... is there a solutions

Many thanks




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date Format Question Josh O. Excel Discussion (Misc queries) 1 February 10th 05 09:45 PM
USING THE DATE FORMAT IN EXCEL teach Excel Discussion (Misc queries) 3 December 14th 04 11:55 PM
Date format collapses diagram Richard H Excel Discussion (Misc queries) 3 December 14th 04 11:08 PM
problem with formatting cell to date format Del Excel Worksheet Functions 7 December 8th 04 05:14 PM
Problem with Date format from VBA code twig Excel Discussion (Misc queries) 3 December 7th 04 06:01 PM


All times are GMT +1. The time now is 07:18 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017