how do you type "power" in one go

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
Congratulations on your binary achievement, Erik. :-)
 
Erik - you are an international man of mystery - I couldn't possibly reveal your secret!
(Oaktree apparently has no such compunction ;) )
 
Erik

Although my background is in mathematics, I don't think I would have worked this out if it weren't for the hints provided.

As it turns out, yesteday I must have got to be 2^-(2^0) as good as you. ;)
 
Last edited:
Y^ep, Pe^ter^,
Problem^ wi^th t^hose milest.nes is that the next one is always further ...... How will I ever get there? ... Don't count on me, anyway not in the Lounge ........ But let's :beerchug: ....
 
Y^ep, Pe^ter^,
Problem^ wi^th t^hose milest.nes is that the next one is always further. How will I ever get there?

Felicitations, Erik!

Took me a while to figure it out, but without meaning to sound rude, aren't you already past it?:laugh:
 
no enigma in this message, just straight text :-)

I am waiting for Greg Truby to reveal the mistery: he should know
(wondering why he didn't show up here: perhaps because there was an invitation to divert the thread)
 
seems like Greg is not in the neighbourhood
so here it is

2^14 = 16384
I started this thread just before my post 16384

Y^ep, Pe^ter^, Problem^ wi^th t^hose
(1 character ^ 6 characters ^ etcetera)

. ...... ... ........ ....

(typo on purpose, was the "s" to get 6 characers in that word)
O thanks you pakistan riaz

as always, just playing :lol:
 

Forum statistics

Threads
1,225,367
Messages
6,184,542
Members
453,241
Latest member
rahuldev31

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top