substitute "." with "" and give format

**danusko** · 03-02-2009, 05:19 AM

Hi,
pls. can you help me?
what is wrong in this code?
i want in all selected number substitute "." with blank, multiply all selected cells with 1 and give this number format #,##0.00

but it works only for last selected cell
pls. what is wrong?

Please Login or Register  to view this content.

**danusko** · 03-02-2009, 05:30 AM

I thing i gave it in bad part of forum

but i solved it my self

here it is:

Please Login or Register  to view this content.

**danusko** · 03-03-2009, 06:55 AM

hi all,
pls. now i found it out, that this code doesnt works good. If is in the number only comma without dot, it multiply the number by 100

I want convert for example number
10.205.356,46
to
10 205 356,46

What is wrong in this code please?
in atach is example the RED number convert wrong

Please Login or Register  to view this content.

**danusko** · 03-04-2009, 04:03 AM

please can you help me with this code?
thank you

**danusko** · 03-05-2009, 04:00 AM

I wrote this problem in other forum too, because nobody here help me.
It is on link:
http://www.vbaexpress.com/forum/show...824#post177824
thx.

substitute "." with "" and give format

LinkBack

Thread Tools

Rate This Thread

Display

substitute "." with "" and give format

Re: substitute "." with "" and give format

Re: substitute "." with "" and give format

Re: substitute "." with "" and give format

Re: substitute "." with "" and give format

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions