Thread: Keeping the exponent at a fix value in Excel
View Single Post
  #1   Report Post  
Posted to sci.electronics.design,microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
WayneL[_2_] WayneL[_2_] is offline
external usenet poster
  
Posts: 5
Default Keeping the exponent at a fix value in Excel
Hi

When formatting in Scientific, how can you keep the exponent constant and
allow the decimal point to move?
For example

If I have:
6.647E-03
1.741E-02
8.378E-02

How do I ensure that Excel keeps the E to E-3 and adjust the decimal point?

Cheers


WayneL


Reply With QuoteReply With Quote