+ Reply to Thread
Results 1 to 2 of 2

1.25 to 1,25

  1. #1
    Registered User
    Join Date
    09-05-2005
    Posts
    10

    1.25 to 1,25

    Hey,

    I am working in an excel sheet. In a row are 100's of values.

    I want to change . to ,

    So, I have for example the number 1.25 and I want to change it into 1,25.



    Manually is too much work.

    Thank's in advance.

  2. #2
    Forum Expert swatsp0p's Avatar
    Join Date
    10-07-2004
    Location
    Kentucky, USA
    MS-Off Ver
    Excel 2010
    Posts
    1,545
    Try Find/Replace:

    Find what: .
    Replace with: ,

    Replace All

    Note that this makes the entries Text, and not available for calculations. Is this what you want? If you are looking to change the decimal to a comma for regional compliance, you need to adjust your settings in Windows>Settings>Regional and Language>Regional Options and pick the country you want to match. Click Apply.

    Good Luck

    Bruce
    Last edited by swatsp0p; 09-13-2005 at 10:49 AM.
    Bruce
    The older I get, the better I used to be.
    USA

+ 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