Re: [libreoffice-users] Calc airithmetic snafu

HI ANDREW, On 2021/11/26 16:38, Andrew Pitonyak wrote: Left will return a string so convert to a number using value... Something like this =Value(left()) THANK YOU Works as expected,now on to the next formula Challenge Get BlueMail for Android On Nov 26, 2021,

Re: [libreoffice-users] Calc airithmetic snafu

Left will return a string so convert to a number using value... Something like this =Value(left()) ⁣Get BlueMail for Android ​ On Nov 26, 2021, 9:12 AM, at 9:12 AM, "Hylton Conacher (ZR1HPC)" wrote: >Hi, > >Using LO 7.2.2.2 Calc on iMac 11.6.1(Big Sur). > >I have a data column that ends

[libreoffice-users] Calc airithmetic snafu

Hi, Using LO 7.2.2.2 Calc on iMac 11.6.1(Big Sur). I have a data column that ends in alphabetic letters i.e.   C      |  D 2| 2.4 km|    2.4 3| 4.8 km|    4.8 As the ' km' can't be added in column C, I used the LEFT formula to only extract the first 3 digits, namely =LEFT(C2,3). This works