How to differentiate from within VB code module, between Excel 'cell types', i.e. 'general', 'numeric', 'text', 'formula' etc.?
Example:
Test and return a difference between;
"1234" in Excel 'general' format cell
and
"1234" in 'numeric' format cell

IsNumeric can't tell the difference.
I think I need to look at special Excel functions actioned from VBmodule??

Any help gratefully received...