on 4/10/2012, Ron Rosenfeld supposed :
On Mon, 09 Apr 2012 22:51:44 -0400, GS wrote:

Any formula that needs to use the resulting string could wrap it in the
VALUE() function so it can be used in calcs. Not sure, though, how it
might work in the proposed format. Some parsing methodology would
definitely need to be used...

I believe that the VALUE function, when applied to the fractional format,
will try to interpret the string as a date. So, depending on the magnitude
of the values, actually the magnitude of the numerator, and probably also
depending on the Windows Regional date format settings, the result will be
either a !VALUE# error, or an unexpected value.

Parsing would be required to use either value in a subsequent formula.

My point exactly, Ron!

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion