Cell contents over 1024 characters will not center or right align

wilkisa

Well-known Member
Joined
Apr 7, 2002
Messages
649
Excel 2013. My user has a cell in which he enters contract numbers one after another in the single cell, ie., 123456, 234567, 345678, etc. The cell is 15 characters wide and the default height. He does not want the cell size changed. Each day, or several times a day, he has to add a new contract number to the end of the list. When it was still a reasonably short list, the cell would always display the last number in the list. He could then F2 and add the new number to the end which was then visible in the cell. He has discovered that, as time has passed that he is no longer seeing the last contract. Instead, he is seeing the number that is at the 1024 character mark (his cell has 2453 characters). His alignment is Right-Indent. Changed to Center alignment and it focuses on the midway point between 1 and 1024.

This isn't a show-stopper but more a curiosity. Can someone explain why it performs this way?
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

wilkisa

Well-known Member
Joined
Apr 7, 2002
Messages
649
Thank you for your reply but I'm not sure what you want me to see in the link provided. I know the cell limitations are not being met so that shouldn't be an issue. We don't want to add yet another cell in this document as it is a form his department uses and they won't allow structure modification. The issue is really very simple, though. When the cell contents are less than 1024 and alignment is RIGHT (INDENTED), the last item in the text displays perfectly in the cell without resizing it. Once the content is more than 1024, it will not display the additional data regardless of alignment. Again, this isn't a show stopper but more a curiosity and annoyance.
 

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,524
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
probably a bug that is not known about and i can't think of a reason to keep incrementing to the right (beyond that is happening here)
 

wilkisa

Well-known Member
Joined
Apr 7, 2002
Messages
649
Yes, Mole999, I concluded that it was a bug that is not high on the priority fix list. I just hoped that maybe it was something I was overlooking. I appreciate your responses, however, and am glad someone else sees it the same way I do.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,350
Messages
5,528,191
Members
409,807
Latest member
nicky736

This Week's Hot Topics

  • Change military grades into rank
    Afternoon all Need help with formula that will change military rank (i.e. 1, 2, 3 into Amn, A1C, SrA). Running IF formula that does not work...
  • VBA COUNTIF SOLUTION
    Hi The following are the errors spread across the several columns from E to Q ie. 13 columns across several sheets with more than 500 rows per...
  • INSERT ROW WITH SPECIFIS TEXT IN A COLUMN
    Hi All! How can identify that that the row to be inserted has to be inserted before 1st row with specific text in column F. If I record the...
  • Auto-Create a monthly Sign in sheet for preschool students
    The image below is what each page looks like. Above is space for the "Child Name" "Month" "Class" School days are obviously Monday-Friday but...
  • VBA vlookup multiple results
    Hi folks, Hopefully someone out there can help. I have a list to vlookup which works (ish). the lookup only picks up the first instance of the...
  • Extract values for earliest/latest times
    I am trying to put together a formula to get the earliest start time, the latest end time from column A for each person in Column B-F without the...
Top