C
Corren
WinXP, Excel 2007
I am unable to show this number in a cell. How do I do it?
Thank you.
I am unable to show this number in a cell. How do I do it?
Thank you.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
I'm not exactly sure what format you're wanting, so here's several.
If your wanting to display "10^6" exactly liek that, and you don't need it
for a calculation, try putting an apostrophe in front of it to tell Excel
that you want to display exactly as you write.
'10^6
If you need to use in calculation, try formatting the cell to scientific.
YOu can then set how many decimal places you want.
Hope this helps!
If your wanting to display "10^6" exactly liek that, and you don't need it
for a calculation, try putting an apostrophe in front of it to tell Excel
that you want to display exactly as you write.
'10^6
If you need to use in calculation, try formatting the cell to scientific.
YOu can then set how many decimal places you want.
Hope this helps!
G
Guest
why not type
=10^6
The result will be 1000000
Mike
=10^6
The result will be 1000000
Mike
C
Corren
Thank you. I should have been more explicit.
I need to show, ten to the power of 6 with the number six as
superscript. I was able to show 10³ but not the other one. It always
defaults to 106.
I need to show, ten to the power of 6 with the number six as
superscript. I was able to show 10³ but not the other one. It always
defaults to 106.
M
macropod
Hi Corren,
Type '106' into the cell, then select the '6' and superscript it.
Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------
Thank you. I should have been more explicit.
I need to show, ten to the power of 6 with the number six as
superscript. I was able to show 10³ but not the other one. It always
defaults to 106.
Type '106' into the cell, then select the '6' and superscript it.
Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------
Thank you. I should have been more explicit.
I need to show, ten to the power of 6 with the number six as
superscript. I was able to show 10³ but not the other one. It always
defaults to 106.
D
Dave Peterson
Format the cell as text
Type in 106
Select the 6 in the formulabar
format|Cells (and make the 6 superscript)
You could also prefix the entry with an apostrophe to make it text: '106
Type in 106
Select the 6 in the formulabar
format|Cells (and make the 6 superscript)
You could also prefix the entry with an apostrophe to make it text: '106
C
Corren
My problem is showing ten to the power of 6 or 12 as 10 with 6 as a
superscript, like in 10³.
Thank you.
superscript, like in 10³.
Thank you.
G
Gord Dibben
Corren
Unfortunately 6 has no ascii code to show it as superscript as 2 and 3 have like
Alt + 0178 or 0179
You could use event code to superscript the numbers.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 1 Then Exit Sub
On Error GoTo ErrHandler
Application.EnableEvents = False
With Target
If .Value <> "" Then
.NumberFormat = "@"
.Characters(Start:=(Len(Target)), Length:=1).Font.Superscript = True
End If
End With
ErrHandler:
Application.EnableEvents = True
End Sub
As written the code works only on column A.
This is event code. Right-click on the sheet tab and "View Code".
Copy/paste the above into that sheet module.
Gord Dibben MS Excel MVP
Unfortunately 6 has no ascii code to show it as superscript as 2 and 3 have like
Alt + 0178 or 0179
You could use event code to superscript the numbers.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 1 Then Exit Sub
On Error GoTo ErrHandler
Application.EnableEvents = False
With Target
If .Value <> "" Then
.NumberFormat = "@"
.Characters(Start:=(Len(Target)), Length:=1).Font.Superscript = True
End If
End With
ErrHandler:
Application.EnableEvents = True
End Sub
As written the code works only on column A.
This is event code. Right-click on the sheet tab and "View Code".
Copy/paste the above into that sheet module.
Gord Dibben MS Excel MVP
C
Corren
Thank you.
C
Corren
Format the cell as text
Thanks Dave, this worked.
Type in 106
Select the 6 in the formulabar
format|Cells (and make the 6 superscript)
You could also prefix the entry with an apostrophe to make it text: '106
Thanks Dave, this worked.