How can I make Excel push something like "10.07.26" to the right side of a cell

Question

How can I make Excel push something like "10.07.26" to the right side of a cell

PR 40

When I enter a date like "October 7, 2026," Excel pushes it to the right side of a cell. But when I do it quick, like "10.07.26", it stays on the left side.

How can I get Excel to push those numerical dates to the right? Both in a current workbook, and as default behavior for new ones created.

0 comments

4 answers

Your answer

Answer 1

PR 40

Thanks Emily.

I was hitting Ctrl+F1, not Ctrl+1.

OK when I see that popup window, I can make the changes. But after making those changes, the numbers shift back to the left. In other words, AI answer (2) makes the change that I want; but AI answer (3) reverts it to how it was before. Should I just ignore (3)? I would still need to make this default behavior from here on out. Also, if there was a way to get excel to translate "10.7.26" to Oct-7-2026, that would be fine, too. But that is secondary to getting dates to the right side of the cell.

EmilyS726 271.4K Reputation points Independent Advisor

2026-10-07T21:24:18.8633333+00:00

Do you have something like this on the Home tab
PR 40 Reputation points

2026-10-07T21:29:41.6433333+00:00

Emily, that was my mistake. I can see the popup window; I was entering the wrong input from keyboard.
EmilyS726 271.4K Reputation points Independent Advisor

2026-10-07T21:35:20.8533333+00:00

No worries.

Do you see the option like I highlighted? Because when I used that option, my date at the bottom does seem to stick to the right.

Make sure you are not introducing a dash or other symbols in between.

Answer 2

EmilyS726 271.4K Independent Advisor

After you pressed Ctrl+1, you should see a pop up like this.. It should already default to Number tab.

User's image

0 comments

Answer 3

PR 40

The first part of the AI answer solved the problem with a single, pre-existing date format---it pushed them to the right side, and even converted them (which I didn't ask for) to something like 07 Oct 2026. But the second part was off:

After Excel recognizes the value as a true date, apply the display format wanted:

Select the cells.

Press Ctrl+1.

On the Number tab, select Custom.

In Type, enter a date format such as dd.mm.yy if that matches the required display.

Where is this Number tab?

0 comments

Answer 4

If 10.07.26 stays left-aligned, Excel is treating it as text, not a real date. Real dates are recognized as date values and can then be formatted and used in calculations.

To make Excel recognize and right-align dates:

Enter dates using a format Excel recognizes for the current Windows regional date settings, such as:
- 9/5/2002
- 5-Sep-2002
If the date is already in cells as text, convert it:
- Select the column.
- Go to Data > Text to Columns.
- Select Next twice.
- In step 3, under Column data format, select Date.
- Choose the matching date format and select Finish.
After Excel recognizes the value as a true date, apply the display format wanted:
- Select the cells.
- Press Ctrl+1.
- On the Number tab, select Custom.
- In Type, enter a date format such as dd.mm.yy if that matches the required display.

For new workbooks, Excel’s default date recognition depends on the computer’s Regional and Language Options date settings. Dates entered in a format that does not match that system may be treated as text instead of dates. To have this work by default in new workbooks, use a date entry pattern that matches the Windows regional date system, or change the computer’s date settings so that the typed pattern matches the system date format.

If cells show ##### after formatting, widen the column.

References: