Forum Discussion
Solved
Reducing multiple decimal points in a value
Hi All Would anyone know of a formula in Excel or PowerBI where we can reduce a value of multiple decimal points to just one? I have tried all the usual formulae in Excel but cant seem to locate th...
GavinMc460 Perhaps this:
=LEFT(A1,FIND(".",A1,3)-1)where A1 contains the version number and the first period never occurs after the third character in the text string.
GavinMc460 Perhaps this:
=LEFT(A1,FIND(".",A1,3)-1)where A1 contains the version number and the first period never occurs after the third character in the text string.
Riny_van_Eekelen , thanks very much. That worked perfectly
