Windows 10: Excel 2103 adding digits to column

Discus and support Excel 2103 adding digits to column in Microsoft Office and 365 to solve the problem; 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... Discussion in 'Microsoft Office and 365' started by sam02, May 12, 2019.

  1. sam02 Win User

    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

    :)
     
    sam02, May 12, 2019
    #1

  2. Excel not responding. Trying to format a column of phone numbers.


    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 protections.
    To be certain, I ran the Doc Inspector. I'm still free to do anything to the list.

    The instructions are easy:
    Highlight column, select Format cell, click Custom, in Type, insert XXX-XXX-XXXX, click OK. That didn't work.
    Next, instead of click Custom, I clicked Special, selected phone number, clicked OK.
    Instead of hyphens, if it adds parentheses around the area code. I'm not that picky, although it takes more space.
    That doesn't work either.

    I am less than a novice in Excel when it comes to creating anything. I've managed to fill in others and not have to create my own.

    The only thing that doesn't look like instructions is that the Sample above Type never changes.
    I don't know if it should.


    Excel 2103 adding digits to column [​IMG]


    Thank you.
     
    BellaDonna, May 12, 2019
    #2
  3. Excel column width

    Is there an easy way to change the column width on Excel using WP7? I copy files over from my PC where the data fits inside the column width but when I open on WP7 I see "xxxxxxxxx" in the column meaning the data won't fit. I've tried moving columns with
    my fingernail after enlarging the spreadsheet but can't get it to do anything. Is the only approach to make the columns wider on the PC version first?
     
    buzzzqwert, May 12, 2019
    #3
  4. Rajesh S Win User

    Excel 2103 adding digits to column

    How to delete multiple non-adjacent columns in Excel at the same time?

    I would like to suggest you simple Macro, to delete multiple non-adjacent columns in one stroke.

    N.B.

    • You can replace values in Split("2-4-6",,) with required Column
      numbers like Split("1-3-5").
    • Column's order must be Ascending.
    • With Sheet1, is also editable.
     
    Rajesh S, May 12, 2019
    #4
Thema:

Excel 2103 adding digits to column

Loading...
  1. Excel 2103 adding digits to column - Similar Threads - Excel 2103 adding

  2. Make Excel display text in a column's cells based on the presence of text in neighboring cells

    in Windows 10 Network and Sharing
    Make Excel display text in a column's cells based on the presence of text in neighboring cells: 1-21-19 I have seen some discussions relating to this question that involve formulae that result in text appearing in a column's cells based on the findings of a numerical value in a neighboring cell, or the converse-- a numerical value is made to appear based on a formula...
  3. Third column added to folder view

    in Windows 10 Support
    Third column added to folder view: I don't know if this is something new or if I just never had it happen to me before. When I open a folder with songs listed, a third column is being created on the right side. It has the artist, title at the top, an icon to represent the song, then the same list of properties...
  4. BUG? : Excel forgets the Data Types of Table Columns in Data Model

    in Windows 10 Installation and Upgrade
    BUG? : Excel forgets the Data Types of Table Columns in Data Model: Microsoft Office 365, Version 1809 (Build 10827.20181 Click-to-Run) on Windows 10 Pro, 64-bit, Version 1803, OS Build 17134.345 I have a workbook with three tables in the Data Model, drawn from three tables on separate sheets in the workbook. Whenever I close and re-open...
  5. Adding excel in new context menu

    in Windows 10 Customization
    Adding excel in new context menu: Hi, I'm trying to add excel program in the "new" context menu. [img] I went to regedit (ShellNew) : [HKEY_CLASSES_ROOT]; .xlsx [img] I added "NullFile" key and put it to '1' as proposed in several procedures on the net. I restarted my computer...
  6. Adding columns in the start menu

    in Windows 10 Customization
    Adding columns in the start menu: Hi! Im currently trying to increase the amount of columns displayed to 2. I have a tiny 7 inch screen with DPI set at 150% which makes the start menu only show one column. Do anyone know how to increase this to two? [img] 9011
  7. Desktop Icon Columns

    in Windows 10 Customization
    Desktop Icon Columns: I have lots of shortcut icons on my desktop for files and programs. That means 2 or 3 columns of small icons. It would appear the Win 10 will only allow 1 column. I've messed with the icon spacing and vertical spacing (regedit) and the vertical spacing works but horizontal...
  8. Excel not responding. Trying to format a column of phone numbers.

    in Microsoft Office and 365
    Excel not responding. Trying to format a column of phone numbers.: 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 protections. To be certain, I ran the...
  9. Read from Excel specific columns

    in Microsoft Office and 365
    Read from Excel specific columns: Hallo, seit kurzer Zeit bewege auch ich mich durch das "Matlab-Universum". Demgemäß freue ich mich über jeden kleinen Schritt, der mir gelingt. Nun habe ich jedoch eine Aufgabe erhalten, welche - so denke ich - mein bisheriges Können bei weitem übersteigt. Folgender...
  10. date column

    in Windows 10 Support
    date column: This morning I updated to the latest BitDefender and while doing so their instructions did not indicate to not select uninstall as the installer would complete this task automatically even though a message did pop up asking me to uninstall. I believe this was the reason for...