Maybe if you change the format to one like "25-mar-2012", you can enter
dates in that format with no ambiguity, and later the spreadsheet can be
printed
or displayed in whatever format you want?
Doug
On Wed, Mar 14, 2012 at 10:44 PM, <eric at megageek.com> wrote:
> The dates are being manually entered. The problem is that with the format
> of dd/mm/yy, when the form is corrected, updated or modified, anyone will
> put it in in that format, and it will get reversed and the data will be
> compromised.
>
> Stuart's recommendation works, but I'm afraid as the file moves from
> computer to computer, the date format will be corrupted.
>
> I just don't understand why Excel HAS to change the data as it is
> inputted. There should be a way to turn it off on a form.
>
> (FWIW, it seems that an asterisk in front of the cell format mask prevents
> this, BUT, the asterisk doesn't work in custom formats, and there is no US
> format that is *dd/mm/yy.)
>
> Anyone know any MS knuckleheads I can strangle?
|