##0

Hello, I have a userform with a label "txtRest" using the following code to get the total amount. (this code is in subroutine "txtTotal_Change") Me.txtRest = (IIf(Format(Me.txtTotal, "#,##0") = "", 0, (Format(Me.txtTotal, "#,##0"))) + 0) - (IIf(Format(Me.txtPaid, "#,##0") = "", 0...

Hi I want to write a code to format numbers like the following <tbody> number appears in excel 1200 1,2 K 1599 1,599 k </tbody> I found this code #,##0, but did work as expected. Thank you very much.

I have the folowing formula that has twxt within the formula =IF(B25-C25>0,"The Net Profit "&MID(B3,9,25)&" has increased by "&TEXT(B25-C25,"R#0,##0"), IF(B25-C25<0,"The Net Profit "&MID(B3,9,25)&" has decreased by "&TEXT(B25-C25,"R(#0,##0)")&" VS")) I need to amend this to read as...

Hi, I have a workbook with a macro which generates 147+ pages. i would like to have first page, last page and rest of the pages different. my footer should give the count of rows printed till the current page. I am also breaking pages such as each page has 35 rows in it. Below is the code i...

Hi, I have a workbook with a macro which generates 147+ pages. i would like to have first page, last page and rest of the pages different. my footer should give the count of rows printed till the current page. I am also breaking pages such as each page has 35 rows in it. Below is the code i...

Hi I just want to undestand how to read these 2 numbers formats and I think that would help me to understand the reset. I have struggled to understand these 2? why # and 0, and why 0.00 (the dot). and why both # and 0 in the same format? Would appreciate any hint 1) #,##0.00 2) #,##0

Hi If I want to format a cell so if the user enter number like -10000 then excel change it right away to -10,000 in Red color. Is that conditional formatting or custom formatting. Also I have seen in custom formatting a code like this #,##0 what does the 0 mean here? and what i have 2 ##...