![]() The downside, however, is that you lose the ability to perform mathematical operations with the data, because Excel now sees the values as text, not numbers. ![]() This approach affords you greater flexibility than using custom number formats, and it's easier to use than managing conditional formatting rules - just type =MyFormat(12345) instead of 12345. ![]() IntValue = intValue - (Fix(intValue / 100)) * 100 StrReturn = strReturn & Fix(intValue / 100) & "s" If Len(strReturn) > 0 Then strReturn = strReturn & " " StrReturn = strReturn & Fix(intValue / 10000) & "g" In the formula box, enter =A1 10000 Then.Select the "Number" tab, then "Custom", and enter the number format from above:.In the formula box, enter =A1>=0, then click on "Format.".Select "Use a formula to determine which cells to format".Compare this to silver at 16.25/oz and copper at 0.18/oz. As a gold piece it is worth 10-15 more than that based on the historical values of commodity money - the 10-15 representing the degree of trust in the exchangeability of the money. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |