Results 1 to 5 of 5

Lock Cell Date Format NOT Content

Threaded View

  1. #1
    Registered User
    Join Date
    09-10-2009
    Location
    Halifax, Nova Scotia
    MS-Off Ver
    Office 2000 (Work), Office 2003 & 2007 (Home)
    Posts
    6

    Exclamation Lock Cell Date Format NOT Content

    I have a workbook that my employees are required to update. HOWEVER, there seems to be some trouble keeping the same date format. Rather than including instructions on how to input the date, is there a way to have my employees enter the date in whatever form they choose and it transform into my preferred format?

    I want it always to appear as dd-mmm-yy

    Many thanks!
    Last edited by mlmaclean; 09-18-2009 at 12:34 PM. Reason: one more question...

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1