numbers with commas. EX: A1 contains 1,230,100, A2 contains 1,240,300, A3 contains 2,540,500. The range can be bigger but the Macro should be able to pick up each cell from the range and insert an "=" sign in the beginning. So that A1 will contain =1230100. So the idea is to remove the commas in a range so that the value is calculable
Just do a find and replace, replacing comma with nothing
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Find and replace does not work ( I dont know why), but I have a macro which someone had kindly given me in this forum several years ago. Since I dont understand it, but I use it extensively .... can you please make some changes in it so that it can do the job ?
Please Login or Register to view this content.
How about this then.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Unfortunately it does not work and highlights the error : cl.Value = "=" & Replace(cl.Value, ",", "")
Last edited by omega0010; 01-13-2019 at 10:01 AM.
Please Login or Register to view this content.
Yes it does work but only for a specific range.... whereas that Absolute formula workes for any selected range ...Please help by modifying it further ! Tnx
Please Login or Register to view this content.
Solved !
Absolutely Perfect ! Thank you so much !
Very Kind of you to spend your time and effort to help dumb people like me
God Bless !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks