> 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,
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
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