| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro for converting number stored as "text" (or preceeded with ') to "number" formatting
Hello,
I've tried to achieve this with macro recorder, but it writes only the ".select" part... (I used to select the whole range and than pass through the contextual <! menu that appears briefly on the left side of the cell and signals the problem...) What is the VBA instruction for this? Many thanks, Mark P.S: Range("B3").Select Selection.NumberFormat = "0.00" is not functionning in my workbook neither... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro for converting number stored as "text" (or preceeded with ') to "number" formatting
Markx
A workaround I have used it to put activecell.value = activecell.value * 1 Post back if this doesnt work (or if it does) Duncan markx wrote: Hello, I've tried to achieve this with macro recorder, but it writes only the ".select" part... (I used to select the whole range and than pass through the contextual <! menu that appears briefly on the left side of the cell and signals the problem...) What is the VBA instruction for this? Many thanks, Mark P.S: Range("B3").Select Selection.NumberFormat = "0.00" is not functionning in my workbook neither... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pasted values that paste as "number stored as text" | Excel Discussion (Misc queries) | |||
| how i convert "100" to "hundred"( number to text) in excel-2007 | Excel Worksheet Functions | |||
| How do I ignore the "Number stored as text" error message permane. | Excel Discussion (Misc queries) | |||
| Column listed as "Number Stored as Text" - Exported from Access | Excel Programming | |||
| unable to get original cell value from a "number stored as text" | Excel Programming | |||
Linear Mode
