Re: [users] [1.1.4] Date entry formats in Calc

2005-08-24 Thread Don Guy
> It is not as hard as you might think. However, the month, day, and > year that you enter probably needs to be in the same order as the > format for that cell or column. As in your example, having the year > formated last and the entering the year first will not work. > However,

Re: [users] [1.1.4] Date entry formats in Calc

2005-08-24 Thread Dan Lewis
On Wednesday 24 August 2005 12:20 pm, Don Guy wrote: > Hi, > > What (if anything) can I do to cause a spreadsheet to display > date-formatted cells in one format, yet accept data entry in another? > > In my old copy of Star Office I can set up a column to display dates > as "MMM DD, ", yet succ

[users] [1.1.4] Date entry formats in Calc

2005-08-24 Thread Don Guy
Hi, What (if anything) can I do to cause a spreadsheet to display date-formatted cells in one format, yet accept data entry in another? In my old copy of Star Office I can set up a column to display dates as "MMM DD, ", yet successfully enter date values as /MM/DD. Fired up OO for the