Pinned Posts
Forum Widgets
Latest Discussions
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:
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?
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.
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.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?
