ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can Excel display in scientific notation with a 3digit exponent? (https://www.excelbanter.com/excel-discussion-misc-queries/220341-can-excel-display-scientific-notation-3digit-exponent.html)

kentk

Can Excel display in scientific notation with a 3digit exponent?
 
e.g.; 7E-168; I am creating the spreadsheet using Coldfusion, so Custom types
will not help me

JE McGimpsey

Can Excel display in scientific notation with a 3digit exponent?
 
Formatting as General will allow that format (after adjusting decimals)
- do you have a specific example that doesn't work?

In article ,
kentk wrote:

e.g.; 7E-168; I am creating the spreadsheet using Coldfusion, so Custom types
will not help me



All times are GMT +1. The time now is 02:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com