Posted to microsoft.public.excel.misc

kevin

Posts: n/a

change year date

I have data that has dates of 4/25/200, 4/25/20,4/25/2020

How do I change the year to show 2006 without changing the month or day

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 to Change Date Formats	Jessica	Excel Discussion (Misc queries)	2	November 1st 05 06:21 PM
Change general format to US date format	woodlot4	Excel Discussion (Misc queries)	3	October 11th 05 12:29 AM
Date formula: return Quarter and Fiscal Year of a date	Rob	Excel Discussion (Misc queries)	7	May 11th 05 08:48 PM
How would I change a date cell to decrease it by business days?	CNGracin	Excel Discussion (Misc queries)	3	December 15th 04 05:20 PM
How do I set date to change automatically on invoices created wit.	Angel	New Users to Excel	3	November 30th 04 04:10 AM

All times are GMT +1. The time now is 06:46 AM.

About Us

"It's about Microsoft Excel"