| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
capture cell number format with VBA
for example cell number format may be: "0.0%"
Can i detect the format with code? I have a sheet with various cell formats with Before double click I want to convert the number in the cell to a string containing the number with a text "symbol" added to the end of that string Then return the number to it's original format with Round(), etc. My code is working OK but, for example, i am getting 0.2333445 instead of 23% Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Capture conditional format as cell format | Excel Discussion (Misc queries) | |||
| Capture a number from a cell containing numbers and letters | Excel Programming | |||
| Capture Col number | Excel Programming | |||
| Number format based on number format of another cell in another workbook | Excel Programming | |||
| How to capture row number | Excel Programming | |||
Threaded Mode
