| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Determining the data type.
Thanks Per for the solution offered.
"Per Jessen" wrote: Hi Try this function, just notice, that TargetCell has to be a single cell: Function CellNumberFormat(ByRef TargetCell As Range) If TargetCell.Cells.Count 1 Then CellNumberFormat = "#Range" Exit Function End If f = TargetCell.NumberFormat CellNumberFormat = f End Function Regards, Per "satadru" skrev i meddelelsen ... Dear All, Without using the "Format -- Cells -- Number" option, is it possible to determine the data type / format of a particular cell or a range of cells? I am trying to look for a formula or a piece of code which could possibly help me out in this. Many thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Determining the text mode from a variety of data types | Excel Worksheet Functions | |||
| How can i filter data type in a cell? | Excel Discussion (Misc queries) | |||
| Data Type Problem? | Excel Discussion (Misc queries) | |||
| Adding new 'Type' to Format->Number->Time->Type | Excel Discussion (Misc queries) | |||
| Need help determining Chart Type | Charts and Charting in Excel | |||
Hybrid Mode
