| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What is this symbol?
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What is this symbol?
Shift 6 is ^
Generally used as "To the power of", ie 2^3 is 8 Steve On Thu, 26 Oct 2006 18:40:02 +0100, 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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What is this symbol?
I think the OP means the Tilde character "~"
Start Programs Accessories System Tools Character Map and type "tilde" in the "Search for" box. "SteveW" wrote in message news:op.th1h8n0aevjsnp@enigma03... Shift 6 is ^ Generally used as "To the power of", ie 2^3 is 8 Steve On Thu, 26 Oct 2006 18:40:02 +0100, 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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What is this symbol?
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" <gorddibbATshawDOTca wrote in message ... 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! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What is this symbol?
Good point..........
How did OP type it into the post if could not find it? Gord On Thu, 26 Oct 2006 23:39:58 +0100, "Stephen Bye" wrote: 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" <gorddibbATshawDOTca wrote in message .. . 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! Gord Dibben MS Excel MVP |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What is this symbol?
Copy from someplace that already had it and then paste?
Gord Dibben wrote: Good point.......... How did OP type it into the post if could not find it? Gord On Thu, 26 Oct 2006 23:39:58 +0100, "Stephen Bye" wrote: 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" <gorddibbATshawDOTca wrote in message .. . 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! Gord Dibben MS Excel MVP -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What is this symbol?
Thanks Dave
Maybe copied it from the worksheet on which it resides in the formula? On Thu, 26 Oct 2006 21:57:06 -0500, Dave Peterson wrote: Copy from someplace that already had it and then paste? Gord Dibben wrote: Good point.......... How did OP type it into the post if could not find it? Gord On Thu, 26 Oct 2006 23:39:58 +0100, "Stephen Bye" wrote: 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" <gorddibbATshawDOTca wrote in message .. . 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! Gord Dibben MS Excel MVP Gord Dibben MS Excel MVP |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What is this symbol?
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? Gord Dibben wrote: Thanks Dave Maybe copied it from the worksheet on which it resides in the formula? On Thu, 26 Oct 2006 21:57:06 -0500, Dave Peterson wrote: Copy from someplace that already had it and then paste? Gord Dibben wrote: Good point.......... How did OP type it into the post if could not find it? Gord On Thu, 26 Oct 2006 23:39:58 +0100, "Stephen Bye" wrote: 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" <gorddibbATshawDOTca wrote in message .. . 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! Gord Dibben MS Excel MVP Gord Dibben MS Excel MVP -- Dave Peterson |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What is this symbol?
Chip is Chip Pearson.
He has many nice utilities and tips at his site. Dave Peterson wrote: 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? Gord Dibben wrote: Thanks Dave Maybe copied it from the worksheet on which it resides in the formula? On Thu, 26 Oct 2006 21:57:06 -0500, Dave Peterson wrote: Copy from someplace that already had it and then paste? Gord Dibben wrote: Good point.......... How did OP type it into the post if could not find it? Gord On Thu, 26 Oct 2006 23:39:58 +0100, "Stephen Bye" wrote: 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" <gorddibbATshawDOTca wrote in message .. . 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! Gord Dibben MS Excel MVP Gord Dibben MS Excel MVP -- Dave Peterson -- Dave Peterson |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What is this symbol?
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, "Dave Peterson" wrote: Chip is Chip Pearson. He has many nice utilities and tips at his site. Dave Peterson wrote: 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? Gord Dibben wrote: Thanks Dave Maybe copied it from the worksheet on which it resides in the formula? On Thu, 26 Oct 2006 21:57:06 -0500, Dave Peterson wrote: Copy from someplace that already had it and then paste? Gord Dibben wrote: Good point.......... How did OP type it into the post if could not find it? Gord On Thu, 26 Oct 2006 23:39:58 +0100, "Stephen Bye" wrote: 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" <gorddibbATshawDOTca wrote in message .. . 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! Gord Dibben MS Excel MVP Gord Dibben MS Excel MVP -- Dave Peterson -- Dave Peterson |
|
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What is this symbol?
If you try Chip's addin, you'll remove all doubt.
Steve B wrote: 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, "Dave Peterson" wrote: Chip is Chip Pearson. He has many nice utilities and tips at his site. Dave Peterson wrote: 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? Gord Dibben wrote: Thanks Dave Maybe copied it from the worksheet on which it resides in the formula? On Thu, 26 Oct 2006 21:57:06 -0500, Dave Peterson wrote: Copy from someplace that already had it and then paste? Gord Dibben wrote: Good point.......... How did OP type it into the post if could not find it? Gord On Thu, 26 Oct 2006 23:39:58 +0100, "Stephen Bye" wrote: 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" <gorddibbATshawDOTca wrote in message .. . 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! Gord Dibben MS Excel MVP Gord Dibben MS Excel MVP -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Decimal Symbol - point needed | Excel Discussion (Misc queries) | |||
| Macro to insert a symbol | New Users to Excel | |||
| € (euro) symbol in Excel charts | Charts and Charting in Excel | |||
| The Mathematical "Implies" symbol | Excel Discussion (Misc queries) | |||
| I need a symbol but "symbol" in the Insert menu is grayed-out. | Excel Discussion (Misc queries) | |||
Linear Mode
