For a number 42117, it can be displayed as 42117, or 23-Apr-15, or 42,117.00 etc. I want to reference these displayed text appearance in another cell through VBA. How can I get it? I have below customized function and it uses the Text property. It still not work properly and hope someone can point me the right direction. Thanks in advance.
Public Function DisplayText(r As Range) DisplayText = r.Text End Function