Den lör 12 juni 2021 kl 01:05 skrev Dutton <l...@ipadring.net>: > > > Here's what I'd like to > do; > > > 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”. If you are going to use the numbers for calculation as time, you have to convert them first, though, because they only appear as time, but they are just numbers, but you said nothing about calculating so I assume that this is what you want. Kind regards Johnny Rosenberg > > > > > Does anyone know that > can be done in Calc? > > > > > Thank you, > > > Peter Dutton > > > > > -- > 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 > -- 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