LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
stittal
 
Posts: n/a
Default Changing Date Format


I know this seems like an easy one, but I am working on a research
project for the Director of the program that I work for and I need to
change the way birthdate is formatted in a particular column. It reads
year first and then month and day.. 20051024 and he wants it to read
10/24/2005. I assumed I could just go to formatting and change it and
it will not let me. There are 6900 some odd records so there is no
possible way to do them manually.. Can anyone help?


--
stittalPosted from - http://www.officehelp.in

 
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
format date in excel Nigel Excel Discussion (Misc queries) 2 September 15th 05 09:52 PM
Excel keeps converting text to date format John T via OfficeKB.com Excel Discussion (Misc queries) 4 September 12th 05 06:48 PM
Why Does Date Format Change on Chart John Taylor Excel Discussion (Misc queries) 0 September 11th 05 08:16 AM
Imported Date & Time format with calcs. managed in excel from imrp Todd F. Excel Worksheet Functions 0 July 8th 05 09:03 PM
Format Cells - Date options Ben Rum Excel Discussion (Misc queries) 1 May 25th 05 05:53 PM


All times are GMT +1. The time now is 01:22 AM.

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

About Us

"It's about Microsoft Excel"