On 2021-06-12 13:59, Johnny Rosenberg wrote:
Den lör 12 juni 2021 kl 01:05 skrev Dutton:
In cell A1 there's the number 1230
In cell A2 I want the number to appear as 12:30 (a time figure)
If you only mean ”appear”, then just format the cell as:
00”:”00
or
#0":"00
depending on w how you want three digit numbers to appear, ”09:30” or
”9:30”...
Johnny, that's a very nice insight into Calc formatting, with more general
application. Do you recall where you found it?
Kind regards
John
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
