| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Currency Symbols in custom formats when imported from HTML?
If I want to display a number in yen currency, I can easily create a
custom format and type in "(alt-0165-release-alt)#,##0" for example. This gets me the symbol I want and the cell still treated as a number. But, how can I duplicate this same formatting when delivering HTML to Excel through a web query, for example? Creating a simple sheet, saving to html, then simplifying gets me this result which works as I would like it to: <head <style ..excelYen { mso-style-parent:style0; mso-number-format:"\\„\#\,\#\#0\.00"; } </style </head <body <table<tr<td class="excelYen" align=right„123.46</td</tr</table </body </html However, I have 2 questions: 1) Why the need for back-slashes in the mso-number-format? What is the requirement of this string value and when are backslashes needed? 2) How can I deliver the same content but use ¥ as the yen symbol instead of the actual embedded unicode character? Any hints or pointers in the right direction would be greatly appreciated! Matt Kruse |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Currency Symbols in custom formats when imported from HTML?
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Imported Text from two HTML tables looks same but is different | Excel Discussion (Misc queries) | |||
| How do I insert currency symbols in Excel? | Excel Discussion (Misc queries) | |||
| Creating custom chart legen pallettes/styles symbols | Charts and Charting in Excel | |||
| How do I make custom formats with superscript or subscript%3f | Excel Worksheet Functions | |||
| Custom Formats | Excel Discussion (Misc queries) | |||
Linear Mode
