>I went on to implement storing numeric values as text strings, which worked exactly as well as you'd expect.

It can be made to work. I would've gone with Binary-Coded Decimal if IEEE 754 standard isn't precise enough.