LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 07:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"