Re: [libreoffice-users] Calc airithmetic snafu

Or perhaps leave the actual number in the first column and just use a cell format for the "km". i.e. 1) Leave 2.4 in the cell 2) ctrl+1 (cmd+1 mac) to open format cell 3) then in the Format Code type " km" behind the number format. And now your 2.4 will show "2.4 km" in the cell. And you can

Re: [libreoffice-users] Calc airithmetic snafu

Re: Units out of the data. 1. The formula =Value(Left(C1,Find(" ",C1))) will be insensitive to longer--129.4 km-- or less specific--7 km-- distances. 2. When I remove units from a list, usually I'm working a large amount of data and find that the whole spreadsheet works better when source data

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