Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Info: I am trying to work with spreadsheets which contain numerical currency
found in a gaming application. The format of their currency is ------gold --silver -- copper. Due to this formatting, I would like to be able to further distinguish my numbers in the spreadsheet presentation. This would be done by showing XXXXX.XX.XX, utilizing two decimals. I'm unsure of how to go about adding a custom formatting for dual-decimals, while still retaining the ability to perform math on the number. For all purposes, it's okay to store a number such as 1 gold 35 silver 20 copper as 13520 on the backend, as long as Excel shows this number as 1.25.20 to the users' eyes. Since the silver and copper never goes above 99, it's the same thing as 13520. Question: Is there a way to create a custom currency formatting with retains mathematical ability, but displays two decimals? If so, how would I do this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formatting custom currency quirk | Excel Discussion (Misc queries) | |||
Custom Formatting For Multiple Currency Symbols | Excel Discussion (Misc queries) | |||
Comma separator for custom Currency | Excel Discussion (Misc queries) | |||
convert a numerical currency into word format | Excel Worksheet Functions | |||
currency custom fomula | Excel Discussion (Misc queries) |