I used to always use Lotus 123 and became used to writing quite difficult macros etc in it . I have tried to get on with MS Excel, but tought I would try the latest free Lotus offering- as above. When I try to enter a date as they reccomend- =DATE(yymmdd) the cell reads #NAME and not the date. I suspect there is a simple answer - is there?
At the risk of stating the obvious, have you formatted the cell you want the date in to be a date? Under normal circumstances, you would just enter say 01/02/2012 and press Enter, the result would show you the date as you want to see it via the formatting.
TonyV Thanks; it was so obvious I did not consider it!! In old Lotus if you enter, eg 01/02/12 it would think that you wnted to divide each number by the next. I did, funnily enough, look up in the Help how to enter dates and it did refer to using the =DATE(yymmdd) formula. I will have to practice more!! I do miss the old .123 though as I used it for so long and could link it with Freelance presentations for graphs etc. I realise this could be done with Excel and Powerpoint but so far have had no time to learn how to do it. Thanks again.