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....
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....
