+ Reply to Thread
Results 1 to 5 of 5

how can i show from web import data with dot decimal, as comma decimal

  1. #1
    Registered User
    Join Date
    03-10-2012
    Location
    romania
    MS-Off Ver
    Excel 2007
    Posts
    19

    Post how can i show from web import data with dot decimal, as comma decimal

    I am imorting data from web http://www.lme.com/aluminium.asp.
    in my excel 2007 i am getting result with dot decimal as follows

    ALUMINIUM Prompt Date Buyer ($)
    Cash 07.09.2012 1,927.50

    how can i show this result with coma as follows

    ALUMINIUM Prompt Date Buyer ($)
    Cash 07.09.2012 1.927,50

    i have tried to chang option but i need this data to use in coma decimal excel, so it must be imported and converted in comma

    thx

    kaan

  2. #2
    Forum Expert Kevin UK's Avatar
    Join Date
    12-07-2010
    Location
    Radstock, Somerset
    MS-Off Ver
    Excel 2003,2007,2010,2013
    Posts
    1,914

    Re: how can i show from web import data with dot decimal, as comma decimal

    If your data is in A1:

    =SUBSTITUTE(SUBSTITUTE(A1,",","."),".",",",4)

  3. #3
    Registered User
    Join Date
    03-10-2012
    Location
    romania
    MS-Off Ver
    Excel 2007
    Posts
    19

    Re: how can i show from web import data with dot decimal, as comma decimal

    it does not work,

    please see my attachment
    thx
    kaan
    Book2.xlsx

  4. #4
    Registered User
    Join Date
    03-10-2012
    Location
    romania
    MS-Off Ver
    Excel 2007
    Posts
    19

    Re: how can i show from web import data with dot decimal, as comma decimal


  5. #5
    Registered User
    Join Date
    03-10-2012
    Location
    romania
    MS-Off Ver
    Excel 2007
    Posts
    19

    Re: how can i show from web import data with dot decimal, as comma decimal

    Quote Originally Posted by kaan View Post
    Attachment 178823

    sorry wrong excell book2

    see this one
    thank you kevin,

    i have solved the problem with your help. but correct formul is like that

    =SUBSTITUTE(SUBSTITUTE(a1;".";",");",";".";1)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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