[libreoffice-users] Date number has 5 digits

In cell A4 is the following code; ="Monday   "+January.$A5 January.$A5  has the number 27 in it (December 27) What appears in cell A4 as a result is- Monday    44557 What is needed is- Monday    27 I've tried reformatting

[libreoffice-users] Can't delete Conditional Formatting

For whatever reason I can't successfully remove (delete) conditional formatting in the Manage Conditional Formatting window. No matter whether I hit Remove or Edit then Delete no conditional formatting rules are ultimately removed. Yes, they do get deleted when I click Remove but the Ok and

Re: [libreoffice-users] Post format messed up

On 4/19/20 8:11 AM, Peter Dutton wrote: > On 4/19/20 5:08 AM, Valter Mura wrote: >> In data domenica 19 aprile 2020 03:48:56 CEST, Peter Dutton ha scritto: >>> Leave >>> it to a computer to mess everything up. >>> >>> >>> &

Re: [libreoffice-users] Post format messed up

On 4/19/20 5:08 AM, Valter Mura wrote: > In data domenica 19 aprile 2020 03:48:56 CEST, Peter Dutton ha scritto: >> Leave >> it to a computer to mess everything up. >> >> >> >> >> How can >> I prevent the ugly format of th

[libreoffice-users] Post format messed up

Leave it to a computer to mess everything up. How can I prevent the ugly format of the messages I sent to the list? Ain't no rest for the weary. Peter -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] Calc- find & replace with specific formatting

(to find instances of cat)Enter cat in replaceClick other optionsFormat.On font select Bold. Steve- there is no format option within the FindReplace screen and "other options". Then click replace allSteveOn 19/04/2020 10:23, Peter Dutton wrote: In Calc I wa

[libreoffice-users] Calc- find & replace with specific formatting

In Calc I want to find a specific word and replace that word with a bold version of it. For the life of me I can't figure out how! Thank you, Peter Dutton -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems

Re: [libreoffice-users] Adding a / (forward slash)

ward slash) Date:Saturday, April 4, 2020, 8:45 AM To:users@global.libreoffice.org Cc:Peter Dutton At 07:50 04/04/2020 -0400, Peter Dutton wrote:Thanks- the "/" works perfectly.Good-oh!Nothing's easy in this world.Many things are.What has been created in th

Re: [libreoffice-users] Adding a / (forward slash)

rg Cc:Peter Dutton At 20:24 03/04/2020 -0400, Peter Dutton wrote:Here's a formula I'm using=DATEDIF($Begin_Here.$E$76,R4,"d")The above formula returns the day number of the year where $Begin_Here.$E$76 [...] the date of 12/31/19Cell R4 has the date 10 (which

[libreoffice-users] Adding a / (forward slash)

Here's a formula I'm using =DATEDIF($Begin_Here.$E$76,R4,"d") The above formulareturns the day number of the year where; $Begin_Here.$E$76  $Begin_Here is a sheet and $E$76 is a cell (on that sheet) with the date of 12/31/19 Cell R4 has the date