customize todate date format

T

Tony

how to customize todate date format

i use "=now()" but i don't know how to break into yyyy mm dd

i will input some characters between them.

thx a lot.
 
M

Marshall Barton

Tony said:
how to customize todate date format

i use "=now()" but i don't know how to break into yyyy mm dd

i will input some characters between them.
Click to expand...

Check Format Property in Help to see all the options
available for you to use in custom formats. I don't know
what you want to do, but here's an example that does a bunch
of stuff:

yyyy" in month "mm and day "dd
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - exporting serial letters to single documents 0
How to add day to PWA 2016 date format? 0
Print Specific Date Settings not saved for use with PrintPreview 0
Use combo to print report between two sets of dates 1
Converting Birth Date format 1
Date Formats 4
Outlook 365 overriding formatting choices 0
Formatting question: how to format duration (time spent)? 0

Top