FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


Excel custom number format





Indi
Does anyone know if it's possible to make your own custom number formats in Excel 2000 using VBA functions - or anything beyond the simple system they have for positive/negative/zero?

What i want to do is have a custom number format for "engineering" format. Engineering format is close to scientific format, except the exponential is always a multiple of 3. Even better, for specific exponents, the SI prefix could be used, so 5.5 10⁵ becomes 55 10⁶, or even better 55 μ. That would be no problem to do in a VBA function... assuming i could use a VBA function to format numbers....
Related topics
Creating a new Operating System
Plot Multiple Points on Your Own Map
writing COM components in Perl
web design and site optimisation tips
Exporting to Excel and formatting textarea
StringTokenizer in JAVA and Xsl file
Trying to move SQL database
Master Tutorial on SEO
A very good PHP MySQL Tutorial
Money Sep
Catching unused variables
Rubik's Cube
Convert Excel to EPS format
Best filemanager?
Reply to topic    Frihost Forum Index -> Computers -> Software

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.