Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,624
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Scientific notation-one exponent for all values Annette Excel Worksheet Functions 2 March 3rd 08 09:11 PM
EXCEL read a text string as scientific notation Chuck Virtu Excel Discussion (Misc queries) 6 January 4th 08 06:13 PM
Excle should allow define a fix exponent in scientific notation Gamaliel Excel Discussion (Misc queries) 1 May 16th 06 06:15 PM
scientific notation to display 1.8 x 10-5 in Excel feloniousmoney New Users to Excel 1 July 6th 05 10:31 PM
Can I fix the exponent in scientific/engineering format? MrShorty Excel Discussion (Misc queries) 1 June 27th 05 08:12 PM


All times are GMT +1. The time now is 06:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"