Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
If this isn't already possible, it sure should be
Sorry but functions return values. They do not change formats... At least
that is the way that Excel currently works. There is no easy way around it. Adding formats to functions would require a whole pile of overhead that I am just as happy to do without. -- HTH... Jim Thomlinson "Orision" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
If this isn't already possible, it sure should be
I would like to see some new "built-in formats" much like the "ZIP", "ZIP+4",
"Phone Number" and "Social Security". The two i would like to see is an IPv4 set for the 4 octets of an IP address "xxx.xxx.xxx.xxx" and the hexadecimal MAC address format of an alphanumeric separated by colons "00:03:3a:4f:44:ba". I like the ability to export dBase data to Excel for easier manipulation. These formats would help in data entry. Thank You "Jim Thomlinson" wrote: Sorry but functions return values. They do not change formats... At least that is the way that Excel currently works. There is no easy way around it. Adding formats to functions would require a whole pile of overhead that I am just as happy to do without. -- HTH... Jim Thomlinson "Orision" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|