how do i display base 2 to the 7 without having it calculate anythin?

how do i display base 2 to the 7 without having it calculate anythin?

I'm not sure what you are asking here (and by the lack of responses, I'm
guessing no one else is either). Can you provide an example to show what you
have and what you are trying to do with it?

Rick

You have to do a calution, but its simply

=2^7

"Rick Rothstein (MVP - VB)" wrote:

how do i display base 2 to the 7 without having it calculate anythin?

I'm not sure what you are asking here (and by the lack of responses, I'm
guessing no one else is either). Can you provide an example to show what you
have and what you are trying to do with it?

Rick

Hi shumba,

Type '27 in the cell.
Then in the Formula Bar highlight the 7 only
Go to FormatCells and check Superscript

HTH
Martin

"shumba64" wrote in message
...
how do i display base 2 to the 7 without having it calculate anythin?

Martin - Great idea, but I can't make it stick, once I click out or press
return.
It reverts back to 27 versus the 2 with the 7 in subscript..


"MartinW" wrote:

Hi shumba,

Type '27 in the cell.
Then in the Formula Bar highlight the 7 only
Go to FormatCells and check Superscript

HTH
Martin

"shumba64" wrote in message
...
how do i display base 2 to the 7 without having it calculate anythin?

Are you typing the leading apostrophe that Martin suggested?

Jim May wrote:
Martin - Great idea, but I can't make it stick, once I click out or press
return.
It reverts back to 27 versus the 2 with the 7 in subscript..


"MartinW" wrote:


Hi shumba,

Type '27 in the cell.
Then in the Formula Bar highlight the 7 only
Go to FormatCells and check Superscript

HTH
Martin

"shumba64" wrote in message
...

how do i display base 2 to the 7 without having it calculate anythin?





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Just to expand on that. You need to make sure that your input is text,
either by using a leading apostrophe, preformatting the cell as text or
it may happen naturally if you are typing something like 10 x 2³.

HTH
Martin

"Debra Dalgleish" wrote in message
...
Are you typing the leading apostrophe that Martin suggested?

Jim May wrote:
Martin - Great idea, but I can't make it stick, once I click out or press
return.
It reverts back to 27 versus the 2 with the 7 in subscript..


"MartinW" wrote:


Hi shumba,

Type '27 in the cell.
Then in the Formula Bar highlight the 7 only
Go to FormatCells and check Superscript

HTH
Martin

"shumba64" wrote in message
...

how do i display base 2 to the 7 without having it calculate anythin?





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Thanks Debra and Martin..
I did preface my cell with the " ' ", that is '27
before doing that formatting . oh well....
Tks,
Jim

"MartinW" wrote:

Just to expand on that. You need to make sure that your input is text,
either by using a leading apostrophe, preformatting the cell as text or
it may happen naturally if you are typing something like 10 x 2³.

HTH
Martin

"Debra Dalgleish" wrote in message
...
Are you typing the leading apostrophe that Martin suggested?

Jim May wrote:
Martin - Great idea, but I can't make it stick, once I click out or press
return.
It reverts back to 27 versus the 2 with the 7 in subscript..


"MartinW" wrote:


Hi shumba,

Type '27 in the cell.
Then in the Formula Bar highlight the 7 only
Go to FormatCells and check Superscript

HTH
Martin

"shumba64" wrote in message
...

how do i display base 2 to the 7 without having it calculate anythin?





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html