Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Currency to Text | Excel Worksheet Functions | |||
Amount or Numbers in Words | New Users to Excel | |||
Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
Convert Numeric into Text | Excel Worksheet Functions | |||
Spellnumber | Excel Worksheet Functions |