Results 1 to 5 of 5

replace the comma separator to a dot and dot to a comma at the same time

Threaded View

  1. #1
    Registered User
    Join Date
    02-25-2005
    Posts
    38

    replace the comma separator to a dot and dot to a comma at the same time

    I have a set of data in Column A1 to A100

    i need a macro to replace the comma separator to a dot but at the same time, dot separator to a comma separator ?
    but if the number has only comma separator or only dot separator no action should be taken

    for example
    1,765.12 should be like 1.765,12

    but
    if the number contains only dot or only comma no action should be taken
    for example

    1765,12 number should not be changed




    please help
    Last edited by barkiny; 07-24-2010 at 01:38 PM.

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