+ Reply to Thread
Results 1 to 5 of 5

Numbers - Changes

  1. #1
    Registered User
    Join Date
    05-22-2018
    Location
    Greece
    MS-Off Ver
    2007
    Posts
    12

    Cool Numbers - Changes

    Good mornging everyone. Iam a new member here, so hi!

    To the point: I have a document in excel with numbers, titles etc. My problem is all about the numbers. Propably i pressed a button or i dont know what happened. I've a column with the numbers, about 200.
    I made that, like, in the first row i wrote the number 1 then in the second row i wrote the number 2 , i choose the 2 numbers and drag them until 200 so to be automatically.

    When i want to write the number 201, for a reason it shows me the number like this 2 0 1 with spaces. Well i dont know how to solve this. I tried to checked every properties in the menu or with right click in the column of the numbers but i couldnt find it. I didnt make any formatting in the document neither changed the font nor the anything else.

    The column is like

    1
    2
    3
    .
    .
    .
    100
    101
    .
    .
    198
    199
    200
    .
    2 0 1
    2 0 2
    2 0 3


    these number automatically are going like the 201 (obviously) and also the letters have spaces in the next columns. If i have a title in the row 201
    is like 2 0 1 and the title for example International Airoport of London is with spaces.

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: Numbers - Changes

    add 1 in A1. in A2 and drag down = A1+1

  3. #3
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,941

    Re: Numbers - Changes

    Select the cells
    select "clear formats" under "clear" from tool bar (which is in right corner)



    if it not works
    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Last edited by samba_ravi; 05-22-2018 at 03:01 AM.
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  4. #4
    Registered User
    Join Date
    05-22-2018
    Location
    Greece
    MS-Off Ver
    2007
    Posts
    12

    Re: Numbers - Changes

    Hello Paul thank you for the answer! Hmm, i couldnt solve it.

    *Under the row 200 all the text is with spaces..

    Maybe the only way is to copy paste the all text and numbers in a new document in excel and done with this, but if there are a lot of data how it will be possible to find this? Also, the lead (spacing) does excist in excel ?

  5. #5
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,941

    Re: Numbers - Changes

    I think this is may be due to custom cell formats

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 12-17-2015, 12:33 AM
  2. Replies: 7
    Last Post: 02-27-2014, 10:56 PM
  3. [SOLVED] Convert all numbers stored as text or custom formatted to numbers &no decimals - 40 sheets
    By synses in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-19-2013, 01:46 AM
  4. Replies: 8
    Last Post: 11-01-2012, 07:49 PM
  5. Editing Social Security Numbers from current numbers to some with XXXX inserted.
    By davidingilbert in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-01-2012, 03:37 PM
  6. [SOLVED] How to merge a numbers from 3 cells, eliminate repetitive numbers, and sort such numbers?
    By david gonzalez in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-22-2012, 11:59 AM
  7. Replies: 0
    Last Post: 08-23-2005, 03:59 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1