If I have a cell to be formatted as a fraction, is there anyway to get the denominator and numerator of the fraction.
E.g.
If Excel has .26163 as 45/172 in Cell A1, is there anyway to get a cell B1 to show 45 and Cell C1 to show 172?
FYI, 3.26163 lightyears is 1 Parsec.
E.g.
If Excel has .26163 as 45/172 in Cell A1, is there anyway to get a cell B1 to show 45 and Cell C1 to show 172?
FYI, 3.26163 lightyears is 1 Parsec.