Determine format type from strings
Does anyone know if there is an easy or automated way to take a format string
for a numeric cell and determine if it's an Int, Float (with num decimals),
Date, or Time?
Right now we are using a large switch, but there are always new formats that
fall through and end up with the wrong type.
Thanks.
|