Number notation

  • Thread starter Thread starter Fifi
  • Start date Start date
F

Fifi

I having trouble plotting a column of number that was save in scientifi
notation like 6.2F-8, 7.1F-6 etc. I couldn't reformat this as 6.2E-
using the "Format" button. It seems Excel doesn't recognize 6.2F-8 as
number notation. I was able to plot number in 6.2E-8 notation. Is ther
a function to convert this into recognized number notation? Wil
conditional formatting work 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

large numbers as text replaced with scientific notation 2
how to resolve incompatibility of saving an excel to csv format 1
Cell format problem 6
keep cell as text, not number 2
Protect Number Format Only 6
Sorting data with the letter 'E' included 3
How do I prevent Excel from putting 16 digit numbers into scienti. 2
.csv files and Scientific number display 1

Back
Top