LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 31
Default reformatting dates

10/3/2007
Thu Oct 4, 2007
Sat Oct 6, 2007
Tue Oct 9, 2007
Thu Oct 11, 2007
Sat Oct 13, 2007
Mon Oct 15, 2007


I have a series of dates....when I try to reformat them all to m/d/
yyyy only some of them are changing from the current expanded day
month date, year

The first one here changed but the others didn't.

Any suggestions?? I'm thinking I might have to convert them all to
something and then format to what I want.

....Lisa

 
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
Reformatting dates for sorting MEAD5432 Excel Discussion (Misc queries) 2 June 2nd 07 12:41 AM
Reformatting a column Janna Excel Discussion (Misc queries) 4 September 14th 06 03:41 AM
need help reformatting spreadsheet Fatboymedic Excel Discussion (Misc queries) 1 November 15th 05 04:50 PM
Reformatting dates as text AmyTaylor Excel Worksheet Functions 1 November 11th 05 11:25 AM
Reformatting formula Alicia Excel Worksheet Functions 2 June 16th 05 12:25 AM


All times are GMT +1. The time now is 02:31 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"