I am looking for a fix on displaying time in a listbox. Problem is Lotus displays the decimal time and not the formatted time. Anyone have any suggestions on a fix. Thanks
I'm not sure this will be an "exact" fix - however, it might be worth taking a look at.
The "command" I'm about to suggest comes from the "old macro programming language" (which I call "SNAP" - for Super Natural Application Programming - FAR superior language than LotusScript or Visual Basic).
The command, if I recall (I don't have Lotus 123 here at work) is the "{CONTENT}" command, which allows for conversion of a cell's contents to "text" - in the same format. Hopefully, the same command, or a similar version is part of LotusScript, or perhaps LotusScript will still recognize the SNAP commands.
Hope this helps. If I expected a "flood of responses", then I would not have bothered with this suggestion, because others would have probably come up with a better suggestion. However, in checking this Lotus 123 forum on a regular basis, I don't see too much "activity".
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.