the Statistical symbol "Xbar"

[Mike D]

Does anyone know have to get or make an "Xbar" symbol for Excel? I can't seem
to find one in the symbols available

thanks,
mike duclos

[Jim Cone]

Mike,

Take a look at this post...
http://makeashorterlink.com/?A2D012F6C

Jim Cone
San Francisco, USA
Free add-ins...
http://www.realezsites.com/bus/primitivesoftware



"Mike D" <[email protected]>
wrote in message
news:[email protected]
Does anyone know have to get or make an "Xbar" symbol for Excel?
I can't seem to find one in the symbols available
thanks,
mike duclos

[Jerry W. Lewis]

http://groups.google.com/group/micro...aad00398e465f5

Jerry

"Mike D" wrote:

> Does anyone know have to get or make an "Xbar" symbol for Excel? I can't seem
> to find one in the symbols available
>
> thanks,
> mike duclos

[Jack Sons]

Jim,

Equation Editor? Isn't that something from Word? To overbar characters in
Word I use the macro below. I have no idea where to find an overbar
possibility in Excel. Please let me know where I can find it, if there is
any.

Jack Sons
The Netherlands

Sub Overline()
Dim sChar As String
Dim i As Integer
sChar = InputBox("Enter characters to overline", "Overline")
With Selection
For i = 1 To Len(sChar)
..Fields.Add Range:=Selection.Range, Type:=wdFieldEmpty, _
PreserveFormatting:=False
..Delete Unit:=wdCharacter, Count:=1
..TypeText Text:="EQ \s\up6(\f(;" + Mid(sChar, i, 1) + "))"
..Fields.Update
..MoveRight Unit:=wdCharacter, Count:=1
Next
End With
End Sub



"Jim Cone" <[email protected]> schreef in bericht
news:[email protected]...
> Mike,
>
> Take a look at this post...
> http://makeashorterlink.com/?A2D012F6C
>
> Jim Cone
> San Francisco, USA
> Free add-ins...
> http://www.realezsites.com/bus/primitivesoftware
>
>
>
> "Mike D" <[email protected]>
> wrote in message
> news:[email protected]
> Does anyone know have to get or make an "Xbar" symbol for Excel?
> I can't seem to find one in the symbols available
> thanks,
> mike duclos

[Jim Cone]

Jack Sons,

I believe Equation Editor is part of the Office Suite.
The file name is: EQNEDT32.EXE

Jim Cone
San Francisco, USA


"Jack Sons" <[email protected]> wrote in message
news:[email protected]
Jim,
Equation Editor? Isn't that something from Word? To overbar characters in
Word I use the macro below. I have no idea where to find an overbar
possibility in Excel. Please let me know where I can find it, if there is
any.
Jack Sons
The Netherlands

Sub Overline()
Dim sChar As String
Dim i As Integer
sChar = InputBox("Enter characters to overline", "Overline")
With Selection
For i = 1 To Len(sChar)
..Fields.Add Range:=Selection.Range, Type:=wdFieldEmpty, _
PreserveFormatting:=False
..Delete Unit:=wdCharacter, Count:=1
..TypeText Text:="EQ \s\up6(\f(;" + Mid(sChar, i, 1) + "))"
..Fields.Update
..MoveRight Unit:=wdCharacter, Count:=1
Next
End With
End Sub



"Jim Cone" <[email protected]> schreef in bericht
news:[email protected]...
> Mike,
>
> Take a look at this post...
> http://makeashorterlink.com/?A2D012F6C
>
> Jim Cone
> San Francisco, USA
> Free add-ins...
> http://www.realezsites.com/bus/primitivesoftware
>
>
>
> "Mike D" <[email protected]>
> wrote in message
> news:[email protected]
> Does anyone know have to get or make an "Xbar" symbol for Excel?
> I can't seem to find one in the symbols available
> thanks,
> mike duclos

[Jack Sons]

Jim,

Thanks, it was indeed on my Office 2k CD.

Jack.
"Jim Cone" <[email protected]> schreef in bericht
news:%[email protected]...
> Jack Sons,
>
> I believe Equation Editor is part of the Office Suite.
> The file name is: EQNEDT32.EXE
>
> Jim Cone
> San Francisco, USA
>
>
> "Jack Sons" <[email protected]> wrote in message
> news:[email protected]
> Jim,
> Equation Editor? Isn't that something from Word? To overbar characters in
> Word I use the macro below. I have no idea where to find an overbar
> possibility in Excel. Please let me know where I can find it, if there is
> any.
> Jack Sons
> The Netherlands
>
> Sub Overline()
> Dim sChar As String
> Dim i As Integer
> sChar = InputBox("Enter characters to overline", "Overline")
> With Selection
> For i = 1 To Len(sChar)
> .Fields.Add Range:=Selection.Range, Type:=wdFieldEmpty, _
> PreserveFormatting:=False
> .Delete Unit:=wdCharacter, Count:=1
> .TypeText Text:="EQ \s\up6(\f(;" + Mid(sChar, i, 1) + "))"
> .Fields.Update
> .MoveRight Unit:=wdCharacter, Count:=1
> Next
> End With
> End Sub
>
>
>
> "Jim Cone" <[email protected]> schreef in bericht
> news:[email protected]...
>> Mike,
>>
>> Take a look at this post...
>> http://makeashorterlink.com/?A2D012F6C
>>
>> Jim Cone
>> San Francisco, USA
>> Free add-ins...
>> http://www.realezsites.com/bus/primitivesoftware
>>
>>
>>
>> "Mike D" <[email protected]>
>> wrote in message
>> news:[email protected]
>> Does anyone know have to get or make an "Xbar" symbol for Excel?
>> I can't seem to find one in the symbols available
>> thanks,
>> mike duclos
>
>