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).
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?
Office 365 Problems
Hello everyone, I have been experiencing the following problem since today: As soon as I try to open Excel, Word, Outlook, etc., they close again immediately. Online repair and reinstallation did not improve the situation. Some of my colleagues are experiencing the same problem. Background: We roll out updates at intervals. The users who were in the first interval are experiencing these problems. The update interval has been stopped, but unfortunately I can no longer undo the update. The following version is displayed: Version 2509 Build 16.0.19231.20138. The computers are running Windows 11 with the 24H2 update. Does anyone have the same problem or know a solution? Thanks in advance.
Outlook for Mac inserts signatures at the very end of an email chain
Hi community, This seems to be a new issue caused by an Outlook for Mac update in recent months. When reply to an email, the default signature is inserted to the very end of an email chain instead of the end of the reply one is about to draft (in other words, above the attribution "On <data>, <name> wrote ..."). I can currently work around this issue by enabling "when replying or forwarding, use the format of the original message" (under Settings -> Email -> Composing). This seems to be a bug.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?EN-GB locale number formatting
Number format string "#, # # 0 ;[Color3] (#, # # 0 )" is not working when Excel is installed with en-gb locale. Any other language works but en-gb fails to parse "Color" - and expects it to be "Colour". Why is excel not following standard openXML in case of en-gb? How does one solve this portability issue when the workbook is generated on the server?
