How to display result of calculations in engineering notation?
I need to perform (electrical engineering) calculations dispaying the result
in engineering notation rather than scientific notatation, eg, powers of 3, 6, 9 and 12 corresponding to milli, kilo, mega and micro, rather than the Scientific notation offered within Excel. Is there an easy method of setting this up? I'm relative new to spreadsheets and have not used macros etc. Or should I go away and learn to use visual basic instead? Currently using Excel 2003. Peter H. |
How to display result of calculations in engineering notation?
Hi Peter,
Here is an excel website that specializes in engineering. http://www.spreadsheetworld.com/ I'm sure you'll find it useful. Cheers, -- Kevin Lehrbass www.spreadsheetsolutions4u.com "Peter_hph" wrote: I need to perform (electrical engineering) calculations dispaying the result in engineering notation rather than scientific notatation, eg, powers of 3, 6, 9 and 12 corresponding to milli, kilo, mega and micro, rather than the Scientific notation offered within Excel. Is there an easy method of setting this up? I'm relative new to spreadsheets and have not used macros etc. Or should I go away and learn to use visual basic instead? Currently using Excel 2003. Peter H. |
All times are GMT +1. The time now is 10:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com