Hi, Im curious to find out how this is done? It's probably dead simpel but i can't seem to snatch it in google :)
How do you add a line below the text in the cell with padding in the ends (as seen in A12-F12)? I've replicated with borders but the you lose the grey grid.
Thanks!
/Marten
I have a column of project numbers that vary in length. My plan is to write an IF statement to check the length of the Project Number and pad these numbers with 0 so that the formats are the same, max length of 10, if needed.
<tbody>
Current Project Number
New Proj Num
PRJ3
PRJ0000003...
Good day,
I am trying to convert data from an excel spreadsheet into an e-mail via an excel macro (OutMail). The purpose of this e-mail is to inform individuals of their outstanding invoices, with the top line being categories of days outstanding:
"|CURRENT |31-60 |61-90...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.