CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
Mask
Mask

Reputation: 573

Using number formatting on a scientific number changes the value

I have a string which is eval_id = -8880305704784521238 in google sheet.

When I used split formula =SPLIT(A1,"=") it gives me result in scientific number eval_id -8.88031E+18

But when I used number formatting it changes the value of the number.-8880305704784520000 which is not equal to the actual number -8880305704784521238.

How can I fix this issue.

enter image description here

Upvotes: 1

Views: 39

Answers (1)

Marios
Marios

Reputation: 27350

Try this:

=REGEXEXTRACT(A1,"-*\d*.?\d+")

example

or as an array formula (specify the range):

=ARRAYFORMULA(REGEXEXTRACT(A1:A15,"-*\d*.?\d+"))

example

Upvotes: 1

Related Questions