| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
getting a number format from a cell
How do I get the number format from a given cell?
Range("E8").Select str = Selection.NumberFormat Thanks Mike |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
getting a number format from a cell
str = Selection.Cells.NumberFormat
"Mike" wrote: How do I get the number format from a given cell? Range("E8").Select str = Selection.NumberFormat Thanks Mike |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
getting a number format from a cell
Mike:
If you need to see the format, then: Sub Macro1() Dim str As String str = Selection.Cells.NumberFormat MsgBox (str) End Sub will display it. -- Gary''s Student "Robert" wrote: str = Selection.Cells.NumberFormat "Mike" wrote: How do I get the number format from a given cell? Range("E8").Select str = Selection.NumberFormat Thanks Mike |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format cell custom Number format | Excel Worksheet Functions | |||
| Format cell to Number | Excel Discussion (Misc queries) | |||
| Cell Number format | Excel Discussion (Misc queries) | |||
| Format a cell with a custom number format | Excel Worksheet Functions | |||
| Number format based on number format of another cell in another workbook | Excel Programming | |||
Linear Mode
