Recent Discussions
Microsoft 365 Tips for Non-Profits with Limited Budgets
Running a non-profit means balancing passion with practicality. You want to maximize your impact — but every dollar counts. Fortunately, Microsoft 365 offers powerful tools that can help you streamline operations, improve collaboration, and boost productivity — often at little or no cost for eligible non-profits. Here are some smart, budget-friendly ways to make the most of Microsoft 365. https://dellenny.com/microsoft-365-tips-for-non-profits-with-limited-budgets/Spell Number in Bangladeshi/Indian Style By Excel Formula.
On web there is SpellNumber() VBA custom function which spell numbers to word in million, billion. We Bangladesh, India, Pakistan spell amounts like lakh, crore etc. Here is a formula to convert amounts to word in Bangladeshi/Indian style. In attached file there is also a generalize LAMBDA() named function SpellNumberBD(). =LET(x,A2,lr,TEXT(INT(x),"00000000000000"),cr,LEFT(lr,7),lc,RIGHT(lr,7),dec,ROUND(x-INT(x),2)*100,c,CHOOSECOLS, digits,{"One","Two","Three","Four","Five","Six","Seven","Eight","Nine","Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen"}, Tenths,{"Ten","Twenty","Thirty","Fourty","Fifty","Sixty","Seventy","Eighty","Ninety","Hundred"}, SPELL,LAMBDA(val,abr,IFERROR(IF(val<20,c(digits,val),c(Tenths,LEFT(val,1)) & IFERROR(" " & c(digits,RIGHT(val,1)),"")) & SWITCH(abr,6," Lakh ",5," Thousand ",3," Hundred ",1," Poisa Only.",""),"")), Taka,SPELL(--MID(cr,1,2),6) & SPELL(--MID(cr,3,2),5) & SPELL(--MID(cr,5,1),3) & SPELL(--MID(cr,6,2),"") & IF(--cr>0," Crore ","") & SPELL(--MID(lc,1,2),6) & SPELL(--MID(lc,3,2),5) & SPELL(--MID(lc,5,1),3) & SPELL(--MID(lc,6,2),""), Poisa,IF(dec<=0," Taka Only."," Taka And " & SPELL(dec,1)),TRIM(Taka & Poisa)) Alternate Download Link (Google Drive).
Inconsistent “Wrap Text” Behavior Between Excel Desktop and Excel Web
We’ve observed inconsistent behavior with the “Wrap Text” format across different Excel environments (Windows Desktop vs. Web). Steps to Reproduce: Create or open an Excel file. Enter multi-line text in several cells and enable Wrap Text. Save the file locally. Upload it to OneDrive or open it in Excel for Web. Observe the displayed cell content without resizing the columns or reapplying formatting. Observed Behavior: On Excel for Windows (Desktop) → Wrapped text displays correctly. On Excel for Mac (Desktop) → Wrapped text displays correctly. On Excel for Web → Text may not wrap properly by default, requiring manual reapplication of “Wrap Text.” Expected Behavior: Cell content formatted with Wrap Text should display consistently across all Excel platforms (Windows, Mac, and Web) without requiring manual adjustment or reapplication. Excel Mac Desktop: OneDrive:
Cannot Create Conversation on multiple ios and android devices with translator app.
Our schools heavily use the Microsoft Translator application on iOS and Android devices. Starting 10/2 all devices have started receiving the following error message "Cannot create a new conversation, please try again". This has been tested on iOS and Android devices and on multiple networks to verify the issue isn't related to filtering / firewall rules. Application has also been uninstalled / reinstalled and still receive the same error. It's clear this is affecting lots of customers yet we can't get any response from Microsoft on the issue. https://learn.microsoft.com/en-us/answers/questions/5580071/microsoft-translator-conversation-feature-stopped?comment=question#comment-2261689Setting Up Conditional Formatting in Microsoft Lists
Microsoft Lists is a powerful tool for organizing, tracking, and managing information. But beyond just storing data, Lists also lets you visually highlight important details using conditional formatting — a feature that can make your lists more intuitive and actionable at a glance. In this post, we’ll walk through what conditional formatting is, why it’s useful, and how you can set it up step by step. https://dellenny.com/setting-up-conditional-formatting-in-microsoft-lists/
Conditional Formatting
Hello, I am developing a conditional formatting rule that allows me to enter a specific text value, and if it matches the content of another cell, that cell will be highlighted in green. However, instead of highlighting only the matching cell, the entire selected range is being highlighted each time I enter a text value.Microsoft Translator Conversation feature stopped working (“Unable to create new conversation”)
When trying to start a conversation, the mobile app (Android/iOS) shows the message: "Unable to create a new conversation. Try again." (Swedish version: "Det går inte att skapa en ny konversation. Försök igen.") About two weeks ago, the live transcription started to become very slow, with text appearing in large chunks instead of line by line. Shortly after that, the Conversation feature stopped working completely. We have tested this on multiple devices and platforms: – Android (several users, including myself) – iOS (tested by a colleague and a user we support) All users experience the same issue — no new conversation can be created. This function is used as a speech-to-text accessibility tool for deaf and hard-of-hearing users, so it is critical for communication support nationally in Sweden.
Agent in SharePoint option is not visible in the M365 admin center
Agent in SharePoint option is not visible in my M365 admin center under pay as you go service and it's only show Syntex services option not the Agent in SharePoint. As before we were able to see both options like Agent in SharePoint and Syntex services but now Agent in SharePoint is not visible. I have also attached the screenshot where both of the options were visible but now the Agents in SharePoint option is not visible, so is there new update in admin portal or is this is some kind of issue?
Complete Form for various data
I need to create a form to be filled by users; the form should contain areas to add text and other areas to add photos, with a selection and dropdown lists. The form should have restrictions on the word count (a counter of the total words written and the remaining to reach the limit should exist on each tab beside the head of the tab or at the end after the final line), the photo size, and the format. I have tried to make a sample, and this is my best (edit pass is: 123): https://docs.google.com/document/d/1-Y1xjT8rCTEVFBijYS5wTGWSjewSjUKNAPmNaN3D7Qc/edit?usp=sharing I can't remove the highlighting on the text area and can't control or keep the document font and format when pasting from an external source (the current format is corrupted by pasting), and I can't even add the written words counter. Any advice is appreciated in this regard ...Few cells in Date column is no formating
The "Date" column (E)was pulled from another excel file using xlookup. When I Try to format Date column few cells don't change at all. The cells containing dd-mmm-yyyy don't change. The cells containing 30 september 2025 changes when I format date column. I don't have issues with other columns. I tried custom formatting as well on date column but still the same few cells dont change at all. Can someone please help?How to filter visible cells by formula after applying filter to a dataset.
I have a dataset from A1:B11 (in real case many more). I apply a filter on dataset, for example filter data for Retailer1 and Retailer3. I want on a separate sheet to filter these visible cells using formula (not VBA). Preferably using a generic LAMBDA function like =FILTERVISIBLE(A2:B11). Any thought or idea to achieve it?
Allow hidden fields
Hi DingkunXie Can the product team do the following: Create an option to make a field hidden or read-only Allow URL parameters to populate the hidden or read-only field Currently we can use a workaround to hide a field using branching logic, but the hidden field can't be prepopulated with the URL parameter :( This small change will unlock a huge amount of value in the product! Especially in the age of automation and Copilot. Looking forward to seeing this happen :)
Excel formula to determine missing numbers
In column S of Sheet 1 I have a list of case numbers. They all start with the year that the incident occurred &, followed by the incident number. On Sheet 2, I want to be able to quickly determine if any numbers in the sequence have been skipped. For instance, 2024-033, 2025-001, 2025-003, etc. There are never a set number of cases per year, so it wouldn't matter whether there should've been a 2024-034 after #33, but I would need to be able to readily see that 2025-002 was never input. If it matters, each year begins with '001' and not '000' and I'm working with Excel 2016.Conditional Access enforces MFA but Service Account still ask to secure account
Hi, I've setup Conditional Access policies to enforce MFA. But it excludes a group for service accounts. Whenever we login to a Service Account, they all ask to secure your account. Hit next > It says no MFA options are available > Skip. Both our own MFA conditional access policy and MS per-user conditional access policy excludes this group. The Legacy per-user authentication policy has all accounts disabled there in favour of the conditional access policy. We must be missing something here. Some of these are shared inboxes, others regular user accounts. Many of these services requires login through the typical Microsoft sign in screen to authorize access. Some does not support OpenID. So how do I 100% exclude service accounts from MFA? And how do I get rid of this popup to secure these accounts when it says no MFA options are available? TIAGroup objects
Hi, I am a longtime user of Word. I have just transferred to a new and stronger laptop; however, when trying to group more than 5 items Word stops responding and sometimes crashes. I disabled all add-ons, hoping it would help. Any ideas? I usually insert the figure in a table and just group the callouts and text boxes with arrows.
Recent Blogs
- You used to have to rely on external tools to crop a picture before putting it in OneNote. Not anymore!Oct 09, 2025
- Thanks to new enhancements in how images are anchored to surrounding text, screen readers can now detect and navigate floating images effectively.Oct 07, 2025
