What is this symbol?

[Guest]

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!

 

[SteveW]

Shift 6 is ^

Generally used as "To the power of", ie 2^3 is 8

Steve

 

[Stephen Bye]

I think the OP means the Tilde character "~"

Start > Programs > Accessories > System Tools > Character Map
and type "tilde" in the "Search for" box.

Shift 6 is ^

Generally used as "To the power of", ie 2^3 is 8

Steve

 

[Gord Dibben]

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

 

[Stephen Bye]

I think it's meant to be a tilde, because if the OP can type ^ in the posted
message, surely they can type the same character in Excel

 

[Gord Dibben]

Good point..........

How did OP type it into the post if could not find it?


Gord

I think it's meant to be a tilde, because if the OP can type ^ in the posted
message, surely they can type the same character in Excel

Gord Dibben MS Excel MVP

 

[Dave Peterson]

Copy from someplace that already had it and then paste?

 

[Gord Dibben]

Thanks Dave

Maybe copied it from the worksheet on which it resides in the formula?

Copy from someplace that already had it and then paste?

Gord Dibben MS Excel MVP

 

[Dave Peterson]

If it's from a cell in a worksheet, then Chip's CellView addin would help:
http://www.cpearson.com/excel/CellView.htm

I couldn't tell what it was, but my first guess is that it looked like it was
the "not symbol" that was used in many mainframe terminals (^ on today's
keyboard).

Maybe it's the same as ^, but just a different font?

 

[Dave Peterson]

Chip is Chip Pearson.

He has many nice utilities and tips at his site.

 

[Guest]

Thanks All,

Yes, I copied it from the formula. From your input I believe it is the ^ and
-, which was not apparent from looking at it, it appeared to be one symbol.

Regards,

Chip is Chip Pearson.

He has many nice utilities and tips at his site.

 

[Dave Peterson]

If you try Chip's addin, you'll remove all doubt.

Thanks All,

Yes, I copied it from the formula. From your input I believe it is the ^ and
-, which was not apparent from looking at it, it appeared to be one symbol.

Regards,