text

4 Topics

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
Solved
Maciej Fox
May 31, 2023 Place Excel
105KViews
0likes
13Comments
reverse text to columns for .csv import
Hello, I want to reverse the text to columns function, so have the different columns in one again, instead of separated by tab I want them to be separated by commas, for .csv import. Any tips? Many thanks!
milly87
Jul 26, 2019 Place Excel
23KViews
0likes
3Comments
Superscript and Subscript ribbon buttons
Is there any way of getting the Subscript & Superscript buttons into Excel 2013 the same as they are in Word 2013? When you have a lot of text in hundreds of cells which includes m2 and m3 it's not particularly efficient.
Lenoire77
Mar 31, 2019 Place Excel
1.5KViews
0likes
3Comments
Giant stupid numbers
My county assessor provided a CSV download of tax info; and one data field is a parcel number. Here is one 17-digit example: 366629301057000009 what I want to do is format it like this: 36-66-29-301-057.000-009 complete with dashes and the decimal point. I have this value in cell B3. I've tried cell c3=Text(b3,"proper format described") and it does not work. I've tried to copy B into C and do a column format, using "Format Cells, Custom Format" and this also does not work. The =Text function actually starts to work, but get's lost and doesn't format so many digits and it loses the trailing 9 altogether. The original entry for this number in the CSV download appears to just be text; as I cannot reformat it as a number with comma separators or decimals. I am using Office Professional 2007
Headaking
Jan 31, 2019 Place Excel
1.7KViews
0likes
4Comments