Results 1 to 6 of 6

sample mean symbol in Excel

This is a discussion on sample mean symbol in Excel within the Excel Questions forums, part of the Question Forums category; Mr. Excel, How to insert the sample mean symbol, so that the "bar" is centered over x? x − Thank ...

  1. #1
    Board Regular
    Join Date
    Dec 2007
    Posts
    123

    Default sample mean symbol in Excel

    Mr. Excel,

    How to insert the sample mean symbol, so that the "bar" is centered over x?
    x
    Thank you,
    Mariner191

  2. #2
    Board Regular
    Join Date
    Jan 2008
    Posts
    8,302

    Default Re: sample mean symbol in Excel

    Hi, For want of something better !!
    Code:
    "_" "Alt+Enter" "X"
    Then resize the Row height.
    Regards Mick

  3. #3
    Board Regular
    Join Date
    Dec 2007
    Posts
    123

    Default Re: sample mean symbol in Excel

    Mick,
    The solution appears simple, however after typing the sequence, "_" then "Alt+Enter" then "X", am getting a very tall cell, with no content.

    At your conenience, please advise.

    Regards,
    Mark

  4. #4
    Board Regular
    Join Date
    Jan 2008
    Posts
    8,302

    Default Re: sample mean symbol in Excel

    Hi, Not sure what you've done, Maybe try without the Inverted commas,!!!
    Just the symbol _ then click "Alt +Enter" then the symbol X.
    Regards Mick

  5. #5
    New Member
    Join Date
    Nov 2011
    Posts
    1

    Default Re: sample mean symbol in Excel

    Goto the menu Insert> Symbol On the Symbols tab... Select the MS Reference San Serif font From: Unicode (hex) Subset: Private Use Area

  6. #6
    New Member
    Join Date
    Jan 2013
    Posts
    1

    Thumbs up Re: sample mean symbol in Excel

    Quote Originally Posted by excelistrator View Post
    Goto the menu Insert> Symbol On the Symbols tab... Select the MS Reference San Serif font From: Unicode (hex) Subset: Private Use Area
    you are awesome, that works and it should be the best way.Thank you

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com