Date format change.

[karthidhamo]

Hi ,

If any body help how to change the below date format of payment date to modify as Invoice date format. I tried to change using in format cells but couldn't. please support.

Payment date	Invoice date
23/06/2019	05-09-2019

 

[navic]

Use Custom Format
Please see attached workbook

 

[p45cal]

Try selecting a single cell which has the date format you want and Copy it (Ctrl+c on the keyboard.)
Select the cells you want to change the format of, right-click and choose the following:

or, choose Paste Special… and make the following choice before clicking OK:


All the cells you selected will be affected.

 

[karthidhamo]

Thanks for all your reply