How can I covert dates to ccyymmdd?
FormatCellsCustom
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" wrote in message ...
| Thank you for your help
|