+ Reply to Thread
Results 1 to 7 of 7

Excel changing its format for values separated with commas

  1. #1
    Registered User
    Join Date
    04-22-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    4

    Excel changing its format for values separated with commas

    Hello ,

    Can someone help me with the problem.

    I have entered the below numbers which are separated by a comma in one of the cell:

    14155318,14156979,14155318,14156980,14155318,14156981

    But as soon as I press enter, it is combining the entire value and changing to a different format but not staying in the above format which I am expected. Please help with a simple solution

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Excel changing its format for values separated with commas

    Just enter the data with a single quote at start point.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    04-22-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Excel changing its format for values separated with commas

    Thanks that works but iam using this for the java to auto read the excel and input these values in the application. So i can use single quote at the start

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Excel changing its format for values separated with commas

    I don't know about java but you cannot keep that value in excel without treating as text.

  5. #5
    Registered User
    Join Date
    04-22-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Excel changing its format for values separated with commas

    Ok thank you

  6. #6
    Registered User
    Join Date
    04-22-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Excel changing its format for values separated with commas

    Any other solution that someone can suggest please ?

  7. #7
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Excel changing its format for values separated with commas

    Format the range/column/cell as text and enter the input data

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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