Date format in Lotus Symphony 3.0.1 spreadsheet

  john bunyan 16:02 01 Feb 12
Locked
Answered

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?

  john bunyan 16:05 01 Feb 12

It actually says #NAME? when I try to enter the date as above.

  TonyV 19:01 01 Feb 12

john bunyan

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

  TonyV 19:02 01 Feb 12

john bunyan

I think Lotus Symphony now works in a similar way to OpenOffice. That is what I used in the above example.

TonyV

  john bunyan 21:17 01 Feb 12

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.

  TonyV 22:03 01 Feb 12
Answer

john bunyan

Glad it is sorted. If my memory serves me right, I think that formula you quote actually gives the date number rather than a recognisable date!

Cheers

TonyV

This thread is now locked and can not be replied to.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Hands-on with the Star Wars fighting drones you can fly yourself

15 macOS Sierra tips | How to use macOS Sierra: Secret tricks and best new features in Apple's new…