LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
tlc@OTS
 
Posts: n/a
Default HOW DO I FORMAT DATA FROM YY/MM/DD TO MM/DD/YY?

WE RECEIVE DATA FROM CANADA IN THE YY/MM/DD FORMAT AND I WOULD LIKE TO MAKE
THAT DATA IN MM/DD/YY FORMAT - IS THERE A WAY TO DO THIS AND NOT CHANGE THE
DATA ITSELF - BUT RATHER JUST THE WAY IT IS DISPLAYED??? HELP! ANY
SUGGESTIONS PLEASE??!!
 
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
HOW DO I FORMAT DATA FROM YY/MM/DD TO MM/DD/YY? TLH_HELP_DATE Excel Worksheet Functions 0 February 17th 05 08:49 PM
Combining data (numeric format) in multiple cells into one cell (t GNAC SID Excel Discussion (Misc queries) 2 February 7th 05 04:09 PM
conditional format of data tables in charts [email protected] Charts and Charting in Excel 2 January 25th 05 03:56 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM
Format Data Series Markers KB Charts and Charting in Excel 1 November 30th 04 03:37 AM


All times are GMT +1. The time now is 05:44 PM.

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"