Custom date format

[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

 

[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

 

[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

 

[Chirag]

In VBA, the following function will display the current date in the dd.MM.yy
format:
---
Sub MyDateFormat()
MsgBox Format(Now(), "dd.MM.yy")
End Sub
---

- Chirag

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

 

[Guest]

Thank you so much

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

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