Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Just as we can write your own number formats using colors:
[RED][contents=12][BLUE][contents<12] so too should we be able to write our own number formats using formulae: [trunc(contents/12) contents-trunc(contents/12)*12][contents=12] [contents€¯][contents<12] 0 ??/?? That way, we can write our OWN preferred formats for distances, frames, memory (change every 1024 instead of 12 or 10), dates, etc. Basically it would allow us to make Excel use our own number system instead of base ten. In example: Base 10: 1st division: 1 2nd division: 10 3rd division: 100 and so on Base imperialdist: 1st division:0.1 1st display: (.) 2nd division: 12 2nd display: ('') 3rd division: 36 3rd display: (yd) 4th division: 5280 4th display: (mi) ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...el.programming |