IF function for converting latitudes in different formats to the same format

Hello,
i need to evaluate a paleo diversity database in RStudio but to be able to do the i need to "clean up" the database first. I do not have much excel experience yet so please excuse my probably mundane questions/requests.

This is specifically about paleo latitudes (the Q column in the attached excel file)
In the Database longitudinal and latidutinal coordinates are not provided uniformly. They're usually given in degrees but sometimes they're missing the decimal point. (51.234° = 51234)
My idea was to solve this by using an IF function as follows:

IF X > 90 or X< -90 divide by 1000 else return original value

e.g. if the value is 51.234 it returns 51.234; if the value is -51234 it returns -51,234

i've already tried to do it myself using the help function but it wouldnt work.

Thank you, thats exactly what i needed :D
i think part of the problem is switching between the english and german version of excel in which "." and "," are interchanged

how to convert the value to numbers?
ive tried to set the format to "numbers" for the entire column but all it did was adding a ",00" after all values without a "." (e.g. 51234 -> 51234,00 | 51.234 ->51.234)

Thanks in advance

If original has "." instead of ",". Then try something like...
=IF(ABS(SUBSTITUTE(Q8,".",",")*1)>90,SUBSTITUTE(Q8,".",",")/1000,Q8)

Or just add another helper column.
=SUBSTITUTE(Q8,".",",")*1

Alternatively, try

Formula:

Please Login or Register  to view this content.

Thanks again
i went with CK76's 2nd option
just had to exchange some "," for ";" to get it to work for me