VB.net Excel Add-in Find which data type an Excel cell is
Hi
I need to automatically detect which data type shown on the numbers form of the Format
Excel interface is. What VB.net code do I use to do this?
I need to automatically detect which data type shown on the numbers form of the Format
Excel interface is. What VB.net code do I use to do this?
Nasir Razzaq
You mean you want to find out what format has currently been applied to the cell?
ASKER
Yes, thanks.
So far I am using the following function
Public Function GetNumberFormat(MyCell As Range) As String
GetNumberFormat = MyCell.NumberFormat
End Function
So for instance a Number with one decimal place is 0.0 and then with a number separater #,###0,0. See I am really just looking for a list of what each type of cell variation will return
So far I am using the following function
Public Function GetNumberFormat(MyCell As Range) As String
GetNumberFormat = MyCell.NumberFormat
End Function
So for instance a Number with one decimal place is 0.0 and then with a number separater #,###0,0. See I am really just looking for a list of what each type of cell variation will return
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
You are right. It is unreliable