One way to deal with fractional data that shows up as a DATE in Google Sheets.
numbers
A quick rundown of how to remove specific characters from a cell in Google Sheets, in this case it’s numbers… Easy to modify for a variety of uses.