This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have a ton of data in rows and columns and I already have my own headers. I want to format this data as a table, but when I do, Excel changes my headers and WILL NOT let me overwrite it back to what I want (even if I change to format as Text). For example, I have Q3FY13. For some inexplicable reason, it adds a 2 at the end, making it Q3FY132 and will not let me change it, unless I change it to have a letter at the end. How can I make Excel leave my headers alone? In fact, I want it to leave all my content and formatting alone. I just want to reference a data range as a table so I can pivot easily.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Hi,
This is happening because the header Q3FY13 is appearing more than once. Ensure that you have all unique headers for the dataset.