Problems with formating text within a cell.

04.10.2017, 22:09 Uhr | 33 | 1

Hello. Since recently I have an annoying problem with Excel. I have a desktop computer, using Windows 10 Home Edition 64 bit with Excel 2016:

Since a couple of time, Excel is just re-formating my texts within the cells. I am using my familiar format since 20+ years, so I did no major changes here. Right after I open up an Excel file, it re-formats the content in a second. I have a collection of text-modules and as soon as I underline a word or change it to bold characters, Excel converts all following text into MS Sans Serif Size 10. In the attempt to correct this, after the next opening of the file, Excel just makes it happen again (grrr). The initial format (which I use since ever) is Arial Size 11. And this unwanted re-formating happens only in cells, in which I did underline or bold-mark a word, the other cells are not affected.

I sifted through several threads and did some tweaking on the registry and the Excel-options, but without any success.

Has someone a solution for this painfull bug? And don't tell me, that might be a feature ;-)

I put in a picture with an example.

Thank you in advance, guys.

Bye

Matti

SergeiBaklan
Oct 13, 2017
Hi Tom,

It looks like that bug
===
Fixes or workarounds for recent issues in Excel for Windows - Excel
Font formatting is lost when using rich text in Excel 2016 [WORKAROUND]
Last updated: October 11, 2017
ISSUE
When opening a file in Excel 2016 that contains multiple types of text formatting within the same cell, the formatting may be lost. Examples include having some rich text bolded and others in the same cell not bolded, or having different font colors for different characters within the same cell, such as the example below.
===
https://support.office.com/en-us/article/Fixes-or-workarounds-for-recent-issues-in-Excel-for-Windows-49d932ce-0240-49cf-94df-1587d9d97093?ui=en-US&rs=en-US&ad=US

dark47dgf
Copper Contributor
May 31, 2023
I have just encountered the issue in Excel 2021 v2304 Build 16327.20248, and found out the way to solve the issue is to *not* use "Accounting" number format for cell formating, instead use other number formating like General or Text.
Tom Oliver
Copper Contributor
Oct 11, 2017
I believe one of our clients are running into this issue quite a bit - I've attached a sample file that has a single cell, that when you bold a word then save, when re-opened the formatting will be messed up.

Work arounds I've found -
1. When opened in 'protected mode' first the formatting is correct (unfortunatly if someone opens it without protected mode first all the formatting is broken again if they save)
2. Reset the formatting of the cell - changing the font&size for the whole cell seems to clear out any of the faulty formatting.

I still haven't figured out whats causing this and why protected view changes things...

Book1.xlsx11 KB
- JKPieterse
  Silver Contributor
  Oct 11, 2017
  It does not happen for me odd enough. Neither on my Excel 2010, nor my Excel 2016 wrecks the formatting after changing it and saving.
  - JKPieterse
    Silver Contributor
    Oct 11, 2017
    One thing that does stand out however is that the workbooks has acquired a custom style probably due to copying and pasting cells from a different workbook and that the cell in question is formatted using that style.
    Try deleting the custom style Normal 2 and then retry the format change and subsequent save.
SergeiBaklan
MVP
Oct 09, 2017
Hi Matti,

That could be Font mapping/Font substitution issue, please check the latest post in this thread https://superuser.com/questions/959710/why-is-my-windows-10-system-replacing-system-font-typically-a-sans-serif-like-a
JKPieterse
Silver Contributor
Oct 09, 2017
Can you attached a small workbook please?

Forum Discussion

Problems with formating text within a cell.

Share

Resources