+ Reply to Thread
Results 1 to 4 of 4

Code to replace commas with dots

  1. #1
    Registered User
    Join Date
    12-28-2022
    Location
    Canada
    MS-Off Ver
    2021
    Posts
    55

    Code to replace commas with dots

    Hi,

    I have numbers of this format 65,0, there is a comma in it. I want to replace it with dot like this 65.0. The range in which code should make replacement is this E5:BB50. And the sheet name is Sheet3 (Sheet 2).
    Many thanks

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,486

    Re: Code to replace commas with dots

    Possibly

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    12-28-2022
    Location
    Canada
    MS-Off Ver
    2021
    Posts
    55

    Re: Code to replace commas with dots

    Hi davesexcel

    Thanks it worked

  4. #4
    Registered User
    Join Date
    12-28-2022
    Location
    Canada
    MS-Off Ver
    2021
    Posts
    55

    Re: Code to replace commas with dots

    Hi davesexcel

    I also want its solution by using excel formula. Please allow me to post it on Excel Formulas

+ 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. Replacing comma with nothing replaces both dots and commas??
    By rthell in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-03-2014, 07:38 AM
  2. [SOLVED] Code for put in dots, where there is blank
    By abjac in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-08-2014, 10:37 AM
  3. replace Dots for comma both collums
    By JohnDpi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-07-2014, 01:38 PM
  4. Changing dots to commas
    By GoingCrazy in forum Excel General
    Replies: 3
    Last Post: 07-13-2009, 08:06 PM
  5. [SOLVED] find and replace - replace data in rows to separated by commas
    By msdker in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-14-2006, 08:10 PM
  6. Replacing dots with commas using macro
    By maxest in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-06-2006, 11:35 AM
  7. [SOLVED] Change Dots into Commas as Decimal Divider
    By xenia in forum Excel General
    Replies: 3
    Last Post: 08-08-2005, 04:48 AM

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