+ Reply to Thread
Results 1 to 4 of 4

Unable to Unify Font

  1. #1
    Registered User
    Join Date
    08-20-2018
    Location
    Mass, USA
    MS-Off Ver
    2018
    Posts
    21

    Unhappy Unable to Unify Font

    Hi,

    I am having an unusual issue where the formatting of my Document can not be unified. I've attached it to this thread.

    If you look at the document, all of the values in columns C through H have different formatting.

    Even though the values are listed as the same font and size, they are clearly different.
    Even when you CTRL+A and change the font, they will all change together but the letters will be slightly different variants of the same font.

    For example, If you compare the two "C's" in G9 & H10, they are listed as identical, but they are clearly different. They even show differently in the equation bar up top.

    Another example is the "A" in G8.



    All I want to do is unify the formatting without having to retype everything.

    Any ideas? This is extremely frustrating.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    365
    Posts
    8,483

    Re: Unable to Unify Font

    Most of them are Unicode characters rather than normal text.
    One option in I2 & fill down & across
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Then copy & paste the result as values over the original data

  3. #3
    Registered User
    Join Date
    08-20-2018
    Location
    Mass, USA
    MS-Off Ver
    2018
    Posts
    21

    Re: Unable to Unify Font

    That worked, thanks for the help!

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    365
    Posts
    8,483

    Re: Unable to Unify Font

    You're welcome & thanks for the feedback

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Unable to get date in devanagari font
    By mso3 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-05-2014, 01:17 AM
  2. Replies: 15
    Last Post: 05-31-2012, 10:34 AM
  3. Unable to set name property of Font Class
    By booo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-15-2011, 05:46 PM
  4. Unable to set ColorIndex font property?
    By FuzzyDove in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-03-2009, 12:38 PM
  5. [SOLVED] Unable to set the bold property of the font class
    By Izran in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-28-2005, 10:05 AM
  6. Unable to format font after creating sheet
    By Geoff in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-27-2005, 05:05 PM
  7. Unable to Set Underline Property of Font Class
    By Sherwood in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-13-2005, 05:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1