Excel problem

[Vercogen]

How do i convert a number for example:

5700000

to show:

5.7 x 106

edit: the 6 should be raised

 

[Drake2007]

Format cell, number, scientific shows 5.70E+6
is acceptable or no?

 

[Vercogen]

Format cell, number, scientific shows 5.70E+6
is acceptable or no?

thx Drake

Yes more or less, i got the format to show it like that as well, but sometimes instead of 6 it shows 4 or 2 i would like to show 6 always.

and if its possible to show it exactly as in my first post if possible?

 

[Drake2007]

I see no way short of manipulating the number and having a column next to the text with superscript formated on the 6 (left aligned)

=CONCATENATE((5700000/1000000),"x10")
(right aligned)

There's sure to be a more elegant solution but it escapes me now.

 

[Borrels]

I see no way short of manipulating the number and having a column next to the text with superscript formated on the 6 (left aligned)

=CONCATENATE((5700000/1000000),"x10")
(right aligned)

There's sure to be a more elegant solution but it escapes me now.

Yes, you can force engineering notation (-3, 0, 3, 6, 9 as exponent) but, as far as I know, one cannot force it through cell formatting to stick to a specific value.

Doing what Drake2007 suggestion, but with the entire value in one cell:
add a column where you divide your value by 1000000 and setting the cell format to 0.000"E+6" where the number of zeros after the decimal indicating the decimals to be displayed.

 

[Vercogen]

Thanx Borrels, i will try this, and report back

 

[Vercogen]

Thread Necro, maybe we should sticky this for future problems?

I want to write the following formula If 2.7>=D8>=0.78, "Pass", "Fail"

 

[Rkootknir]

Thread Necro, maybe we should sticky this for future problems?

I want to write the following formula If 2.7>=D8>=0.78, "Pass", "Fail"

=IF(AND(D8>=0.78,D8<=2.7),"Pass","Fail")

 

[Vercogen]

=IF(AND(D8>=0.78,D8<=2.7),"Pass","Fail")

Aaahaaa, sweet, Thanks Rkootknir

 

[HavocXphere]

Rather use boolean values, especially if you intend to use the result as an input for another formula - less susceptible to nasty bugs that take ages to hunt down. Will also work out faster (as in processing power) if you're doing hardcore excel sheets with millions of values.

=IF(1=1,TRUE,FALSE)

If its just for presentation, then Rkootknir is 100% correct though.

Not entirely relevant, but I'd thought I'd post this anyway:
=IFERROR(1/0,"FUBAR")