| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
can excel report scientific values rather than absolute numbers?
I'm trying to create a workbook capable of doing the maths behind a
biological calculation. The results are very low (x10 E-6) and i would like to report this with the correct scientic prefix (pico- nano- etc...) is this possible in excel? eg result comes as 3.41323E-06 i would really like 3.41 pMol i can get it down to 2 decimal places but i can't set a rule to 'replace e-06 with pMol' |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error report closing excel | Excel Discussion (Misc queries) | |||
| Can an Excel Invoice link to an Excel Accounts Receivable Report? | Excel Discussion (Misc queries) | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Microsoft Access Report into Excel Spreadsheet | Excel Discussion (Misc queries) | |||
| How do I sort for the maximum values in each year in excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
