| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba format question
cells(1).value = 3
With code I would like to convert this value into 03 for use elsewhere ie:show single digit numbers as 2 digit in a message box I've tried variations of the code below but no joy so far dim txt as string txt = format(cells(1).value, "00") msgbox txt |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| .csv Re-Format Question | Excel Discussion (Misc queries) | |||
| Format Question | Excel Discussion (Misc queries) | |||
| Yet Another Name Format Question | Excel Discussion (Misc queries) | |||
| Format Question | Excel Discussion (Misc queries) | |||
| Format % Question | Excel Worksheet Functions | |||
Threaded Mode
