| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Currency formatting
Thanks for your solution
It works a treat. Nick -----Original Message----- Hi try vstr=format(var,"$0,0.00") or something similar. Note: This way you store it as a string! -- Regards Frank Kabel Frankfurt, Germany "Nick" schrieb im Newsbeitrag ... If I happen to have £120,000,987 in a cell how do I store that in a variable with all its formatting. If I declare a variable as long or currency and store the cells contents then it seems to store 120000987. I wish to print out the number in a string and can't seem to get the commas and £ sign to feed through. Any help is much appreciated as ever. Nick Shinkins . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting currency query | New Users to Excel | |||
| Currency Formatting | Excel Discussion (Misc queries) | |||
| Currency Formatting. | Excel Discussion (Misc queries) | |||
| Currency Formatting | Excel Discussion (Misc queries) | |||
| Conditional Formatting for Currency | Excel Programming | |||
Threaded Mode
