| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add text with formated number using VBA
Hello,
Is it possible to add a text with number using vba and format that number to "[$-2000000]#0" Something like Range("A1")= "Sample Text " & format(12345, "[$-2000000]#0") If add 12345 to Range A1 and say Range("A1").numberformat="[$-2000000]#0" then it works properly Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell that is formated for Date shows a diffrent number | Excel Discussion (Misc queries) | |||
| If Statement - With Formated text | Excel Worksheet Functions | |||
| need to force PT to use formated number | Excel Worksheet Functions | |||
| How do I convert a number formated as a date to text in Excel? | Excel Discussion (Misc queries) | |||
| Copying Formated Text | Excel Programming | |||
![Abdul[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
