Excel 2103 adding digits to column Solved

  1.    #1

    Excel 2103 adding digits to column

    Hi guys can I ask for a little advice please I have an excel 2013 spreadsheet formatted as a table

    I have attached a screenshot to explain better

    As you can see I have a rows of dates in the header row IE 12th 13th 14th and so on to the left of the yellow column but when I add the same dates to the right of the yellow column excel add the digit 2.

    I understand it is telling me that's the second time the same date has been used, but is it possible to stop this please
    Attached Thumbnails Attached Thumbnails excell screenshot.JPG  
      My ComputerSystem Spec

  2. Lugh's Avatar
    Posts : 90
    Windows 10 Home x64 1803

    sam02 said: View Post
    is it possible to stop this please

    It's not that it's the second time you use the same thing. It's that Excel doesn't allow the same heading label to be used for 2+ columns in tables.

    You can get what you want by not formatting it all as a table—ie format as a Range:
    Click Table Tools > Design tab > Tools section > Convert to Range
      My ComputerSystem Spec

  3.    #3

    When you format an Excel spreadsheet as a table you are actually creating a database and the column headings are a data categories. For any database to function it must have different names for each category. Duplicate names are not allowed.
      My ComputerSystem Spec

  4.    #4

    Ok guys thanks for the advice i understand now
      My ComputerSystem Spec


Related Threads
I uninstalled Office 2016 and installed office 2019 on my laptop. Now clicking on existing Powerpoint or Word files created by older 2016 versions can be opened with double clicking on the file name. However, double clicking on the Excel files...
Windows Hello in Windows 10 enables users to sign in to their device using a PIN (Personal Identification Number). You can use this PIN to sign in to Windows, apps, and services. One important difference between a password and a Hello PIN is that...
Excel 2010 I have a column of 22,000 phone numbers (and an additional column of fax numbers). I'm trying to convert the numbers from nine digits to nine digits with hyphens. I copied and renamed the original document. There are no...
Hi, I have a really odd issue where a vertical bar appears in all paths in explorer, on the system clock and explorer date/time stamps. you can see examples below. I've reset my regional settings, and checked the registry for standard digits,...
Hi, I'm trying to add excel program in the "new" context menu. https://www.tenforums.com/attachments/customization/58126-adding-excel-new-context-menu-contextmenu.jpg I went to regedit (ShellNew) : ; .xlsx
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd
All times are GMT -5. The time now is 16:32.
Find Us