Custom date format


G

Guest

Hello all

I (all right, the graphic designer I'm working with - lord those people are
fussy!) would like to have the date format 19.06.07 rather than any of the
standard formats. I read on this wonderful forum that I need VBA to do that.
Can someone get me started/pointed in the right direction as I'm a bit
clueless. Just to give you all a laugh this is how far I've got:
Sub DateFormat()
Date.dd.MM.yy
End Sub
And it appears to do nothing, though at least it's happy with the syntax :)
I tried adding quote marks but that was an invalid use of the property
apparently.

Please help and I promise I'll try harder to learn.

Lucy
--
MOS Master Instructor
www.aneasiertomorrow.com.au

If this post answered your question please let us know as others may be
interested too
 
Ad

Advertisements

C

Chirag

Where do you want this change to reflect? You can get this change
system-wide through Windows Control Panel, launch "Regional and Language
Options", click "Customize this format...", select "Date" tab, and type out
"d.M.yy" in "Short date" area, click OK. This should get you 19.06.07 date
format in PowerPoint as well.

- Chirag

PowerShow - View multiple PowerPoint slide shows simultaneously
http://officeone.mvps.org/powershow/powershow.html
 
G

Guest

Fabulous thank you :)

Is there a way to do it via VBA do you know? Just the client may not want to
change their system-wide settings and it's all about giving people choices...

Lucy
--
MOS Master Instructor
www.aneasiertomorrow.com.au

If this post answered your question please let us know as others may be
interested too
 
Ad

Advertisements


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


Top