Date Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I prefer to input dates with a period (dot) separator rather than a slash or
hyphen. Although I can achieve this by altering the setting in Control
Panel/regional settings, I want the screen display to show/print dates in the
style '01/01/2005' and not '01.01.2005'. I don't think Excel has an input
mask facility in the way that Access does. Why not? Surely there is a need
for this? Is there a work around, please?
 
You can do it within Excel: go to >format > cell > Number. Use Custom to amend as you like.
dd.mm.yyyy, yy-mm-dd . . . . . and so on.
Chong
 
Can I automate this process using visual basic 6

MSN STM said:
You can do it within Excel: go to >format > cell > Number. Use Custom to amend as you like.
dd.mm.yyyy, yy-mm-dd . . . . . and so on.
Chong
Click to expand...
 
Back
Top