View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default What is this symbol?

You post shows ^-

Is this correct or is it just ^

It is a "caret" and can be entered by hitting SHIFT + 6 key.

Most often used as an exponential sign.

=4^2 returns 16..........4*4

=4^3 returns 64..........4*4*4

To add the - sign..............

=4^-2 returns .0625


Gord Dibben MS Excel MVP

On Thu, 26 Oct 2006 10:40:02 -0700, Steve B
wrote:

Hi, Trying to copy a formula that includes this symbol "^-", Can someone tell
me what it is, and where to find in on the keyboard or in symbols?

Thanks!