number format
 

How to put the exponent constant in representation of a number in MS
excel? We can move the decimal point.
E.g. i want to represent 101325 as 1.01e5. similarly 1013250 as
10.13e5. E5 should be constant.


--
carno
------------------------------------------------------------------------
carno's Profile: http://www.excelforum.com/member.php...o&userid=33633
View this thread: http://www.excelforum.com/showthread...hreadid=534054

number format
 

have you tried format custom and then use 0.00E+5?

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=534054

number format
 

I tried that, but it does not give correct results. You can also try and
let me know.

Thanks


--
carno
------------------------------------------------------------------------
carno's Profile: http://www.excelforum.com/member.php...o&userid=33633
View this thread: http://www.excelforum.com/showthread...hreadid=534054

number format
 

If A1 contains the value then:

=A1/100000 & "e5"

seems to work
--
Gary's Student


"carno" wrote:


How to put the exponent constant in representation of a number in MS
excel? We can move the decimal point.
E.g. i want to represent 101325 as 1.01e5. similarly 1013250 as
10.13e5. E5 should be constant.


--
carno
------------------------------------------------------------------------
carno's Profile: http://www.excelforum.com/member.php...o&userid=33633
View this thread: http://www.excelforum.com/showthread...hreadid=534054

number format
 

Nice reply from Gary''s Student. It works. But then we have to have
another cell for that. It is not formatting.


--
carno
------------------------------------------------------------------------
carno's Profile: http://www.excelforum.com/member.php...o&userid=33633
View this thread: http://www.excelforum.com/showthread...hreadid=534054

number format
 

Can't be done with formatting as E will always display 1 digit.

This ain't foirmatting either, but maybe it's okay

'-----------------------------------------------------------------
Private Sub Worksheet_Change(ByVal Target As Range)
'-----------------------------------------------------------------
Const WS_RANGE As String = "A1"

On Error GoTo ws_exit:
Application.EnableEvents = False
If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then
With Target
.Value = Format(.Value / 100000, "0.00") & "E5"
.NumberFormat = "@"
End With
End If

ws_exit:
Application.EnableEvents = True
End Sub

'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.



--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"carno" wrote in
message ...

Nice reply from Gary''s Student. It works. But then we have to have
another cell for that. It is not formatting.


--
carno
------------------------------------------------------------------------
carno's Profile:
http://www.excelforum.com/member.php...o&userid=33633
View this thread: http://www.excelforum.com/showthread...hreadid=534054

number format
 

Thanks a lot Bob


--
carno
------------------------------------------------------------------------
carno's Profile: http://www.excelforum.com/member.php...o&userid=33633
View this thread: http://www.excelforum.com/showthread...hreadid=534054