View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Orision Orision is offline
external usenet poster
 
Posts: 4
Default If this isn't already possible, it sure should be

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