New answers tagged

0

I have found my solution. _(%* #,##0.00_);_(%* (#,##0.00);_(%* "-"??_);_(@_) I was able to use the accounting format as a basis.


1

It turns out that the root certificates were out of date, as suggested by the comments. I downloaded the Windows update "Support for urgent Trusted Root updates for Windows Root Certificate Program in Windows" directly from the Microsoft site, which fixed the problem.


0

I also faced the same problem once but I didn't find any suitable solution. I copy pasted the text into another cell and that solved the problem. I had to copy paste the text of all the cells one by one to the new cell and got rid of the problem. In this way I have moved the text from each cell of the column to the new cell and created the new column and ...


0

Not impossible, but a bit tricky. You want to format the numbering in your first two levels as hidden text. This is done using the Define New MultiLevel List dialog with each level being attached to an existing Style. Follow the directions in general that are set forth in Word MVP Shauna Kelly's instructions. You would need to adjust the indents as well. ...


1

With Office 365 or Excel 2019 use TEXTJOIN and TEXT: =TEXTJOIN(" - ",,TEXT(D5:D6,"$#,##0")) If using in Excel 2019 this may require the use of Ctrl-Shift-Enter instead of Enter when exiting edit mode. If older version then instead of DOLLAR() use TEXT: =TEXT(D5,"$#,##0")&" - "&TEXT(D6,"$#,##0")


0

By default in Windows Vista and later versions, the format command writes zeros to the whole disk when a full format is performed. In Windows XP and earlier versions of Windows, the format command doesn't write zeros to the whole disk when a full format is performed. Do not full format ssd only quick format since it degrade it's life span and on hard disk ...


Top 50 recent answers are included