[Solved] Regain an original fractional numeric value that Excel has transformed to a date value

by


EDIT#1:

If the value ‘42248’ has somehow gotten into A1, then in another cell enter:

=--TEXT(A1,"d.m")

to retrieve the 1.9

5

solved Regain an original fractional numeric value that Excel has transformed to a date value