aligned

  1. P

    Ribbon Editbox Format Control

    Hi Is there a way to control the format of a Ribbon Editbox. I want to display values all right aligned and to 3 decimal places? My Editboxes are populating OK but the responses are all left aligned and no fixed decimal values Cheers Paul
  2. P

    VBA Userfrom Textbox input alignment

    Please can someone assist me. How do I get the text captured in a userform textbox aligned left. It is aligned left, however when the number of characters typed exceeds the textbox size (visually) the text is kept to the right (last character instead of the first character.) I would like the...
  3. M

    vba to clear cell contents if it's left aligned

    I need assistance developing a macro that will clear cell contents based on it's text alignment. I have a column in my excel sheet that contains both project names aligned to the right and subtask names aligned to the left. I need the column to be separated into 2 columns - one with just the...
  4. S

    PowerBI align date ranges from multiple databases

    Good morning, I have 3 databases in PowerBI Dekstop where I select for example the date range of Q2. Weird enough the data that is shown (in a horizontal bar chart) isn't aligned very well. The charts all start in April but the nexts months aren't aligned right above each other. I hope you...
  5. M

    Excel formatted as number but left aligned

    I have a list of product ID (consist of all numbers) generated from another system.However these numbers are already in format number but left aligned. I need them to be number format as I am using this file for another system. Any advice? Thank so much.
  6. S

    Pivot Table Overlapping Solution ?

    I've multiple worksheets in which there are vertically aligned multiple pivot tables and I don't want them to be horizontally aligned. After I remove the filters, the pivot table is supposed to expand but suddenly states overlapping problem. I've to manually leave a lot of rows blank and hide...
  7. S.H.A.D.O.

    Lining up figures when using the "=CONCATENATE" function.

    Good evening, Does anyone know how I can line up 3 sets of figures used in a CONCATENATE function please? My formula is: =CONCATENATE("01 = (M) ",TEXT('Main Table'!E8,"0")," - (B) ",TEXT('Bonus Table'!E8,"0")," - (Both) ",TEXT('Main & Bonus Table'!E8,"0")) It produces this for example: 01 =...

We've detected that you are using an adblocker.

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.
Go back
Back
Top