How can I covert dates to ccyymmdd?

's Computer Specifications

Thank you for your help

's Computer Specifications

Format>Cells>Custom
In the Type box, enter:
yyyymmdd

If you need a text string that has these digits:

=TEXT(A1,"yyyymmdd")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Payroll" <(E-Mail Removed)> wrote in message news:449C34CD-7466-4347-BF7E-(E-Mail Removed)...
| Thank you for your help

's Computer Specifications

HI,

try

=left(year(a2),2)&text(a2,"yymmdd")

hth
regards from Brazil
Marcelo

"Payroll" escreveu:

> Thank you for your help

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
covert xls to xml	sawyer	Microsoft Excel Programming	0	11th Nov 2008 03:51 PM
Convert int ccyymmdd to date(time)	patf@well.com	Microsoft Excel Worksheet Functions	9	25th Jul 2008 01:17 AM
Can Excel (2003) reverse date from ccyymmdd to mmddccyy?	=?Utf-8?B?RG9u?=	Microsoft Excel Misc	6	25th Jul 2007 01:17 AM
ccyymmdd to dd/mm/yyyy from query	=?Utf-8?B?QW5keQ==?=	Microsoft Access Queries	2	27th Jun 2007 04:12 PM
Convert mmddccyy to ccyymmdd?	=?Utf-8?B?UGF1bGFW?=	Microsoft Access	3	13th May 2005 09:59 PM