View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Manish Patel Manish Patel is offline
external usenet poster
 
Posts: 1
Default How Can I conver date i.e 18/11/2005 to 18112005.?

Hi

I am doing one Pruchase Order form in Excel.

I want to creat the PO number as if date being Displayed in regular number.
i.e 18/11/2005 as if 18112005 and than followed by "-" and increasing value.

If I will open and print off 5 times in a day. The last number has to be
18112005-5.

Is there anybody can help me on it.

Kind Regards

Manish