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)" <hylton@conacher.co.za> wrote:
> 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 wonderfully 
> in column D, BUT whilst not shown on the spreadsheet, the numbers are 
> shown in-between double quotes if one looks at the formula, in column
> D, 
> with the Function Wizard, which again does not enable the number to be 
> added, averaged etc.
>
> Both C, D columns are formatted as Number with a single decimal point 
> and there will be no -ve number.
>
> What am I missing, and where to rectify it?
>
> Regards
> Hylton
>
> -- 
> To unsubscribe e-mail to: users+unsubscribe@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+unsubscribe@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