If this isn't already possible, it sure should be

[Guest]

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/com...89ba5d5&dg=microsoft.public.excel.programming

 

[Guest]

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.

 

[Tushar Mehta]

That would be a very useful capability.

Though, if I were in your shoes I wouldn't hold my breadth waiting for MS to
implement it.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Guest]

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

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

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/com...89ba5d5&dg=microsoft.public.excel.programming