| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using a row filled with strings to determine cell value | Excel Discussion (Misc queries) | |||
| Routine with fuzzy logic to determine the relative comparison of two strings? | Excel Worksheet Functions | |||
| Determine file type | Excel Programming | |||
| Type mismatch error problem when dealing with Strings | Excel Programming | |||
| Help - Type mismatch when running loop with strings from arrays | Excel Programming | |||
Threaded Mode
