Display all values as x.xxx+06?

  • Thread starter Thread starter Annette
  • Start date Start date
A

Annette

I have a worksheet that is used by our group and many values are filled in
that are in that range of 10e4 or 10e5. For purposes of comparison, we would
like all entries to display as 10e6 in the worsheet. Is there a way to
format the cells so that when we enter a number like 12400, it will display
as 0.0124e6?
Thanks
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

modify all formula references in multiple cells 3
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
data validation rule 4
Excel VBA 1
Time Values As Numbers 3
Excel Stop Excel from displaying rounded values 4
Remembrance 2018 4
excel displays formula instead of value in one cell 3

Back
Top