ok, thank you;)
Dne úterý, 11. listopadu 2014 6:47:02 UTC+1 Vabz napsal(a):
>
> Once you are in the Account Settings, look under 'Personal Info', and look
> at the current Country/Region of your account it should be Czech Republic
> to change it to comma instead of dot.
>
> +
> *I did not do
Once you are in the Account Settings, look under 'Personal Info', and look
at the current Country/Region of your account it should be Czech Republic
to change it to comma instead of dot.
+
*I did not do this for you. God is here working through me for you.*
On Tue, Nov 11, 2014 at 2:56 AM, iv
Great, thank you, Vabz! Yes, could be;)
Dne neděle, 9. listopadu 2014 20:05:10 UTC+1 Vabz napsal(a):
>
> Ok, here you go..
>
> Also do you need to change no. format to match with your native currency?
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Sun, Nov
Ok, here you go..
Also do you need to change no. format to match with your native currency?
+
*I did not do this for you. God is here working through me for you.*
On Sun, Nov 9, 2014 at 11:49 PM, ivavok
wrote:
> Hi,
>
> that´s perfect! Thanks. Just the comma is decimal not between thousand
Hi,
that´s perfect! Thanks. Just the comma is decimal not between thousands. So
the first figure should be 15 750,00 and not 1 575 000,00...How should I
change the macro so that it works this way?
Thank you in advance!
Dne neděle, 9. listopadu 2014 15:20:35 UTC+1 Vabz napsal(a):
>
> Hi
>
> Try
Your welcome Ivaana
Regards
Pramod
Www.facebook.com/Pramodbish
Pramod
On 9 Nov 2014 18:45, "ivavok" wrote:
> Hi,
>
> thank you, that´s perfect!
>
> Dne neděle, 9. listopadu 2014 5:08:16 UTC+1 pramodb35 napsal(a):
>>
>> Hi Dear,
>>
>>
>> Please find the attached file. Hope this will be fine for
Hi
Try this, Run macro by clicking blue button, select range containing number
when prompted!!
You will get output as desired without help of any helper sheet.
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Sat, Nov 8, 2014 at 1:46 PM, ivavok
wrote:
>
Hi,
thank you, that´s perfect!
Dne neděle, 9. listopadu 2014 5:08:16 UTC+1 pramodb35 napsal(a):
>
> Hi Dear,
>
>
> Please find the attached file. Hope this will be fine for you.
>
> Regards
> Pramod
>
> On Sun, Nov 9, 2014 at 1:05 AM, ivavok > wrote:
> > Hi PramodSingh ,
> >
> > T
Hi Dear,
Please find the attached file. Hope this will be fine for you.
Regards
Pramod
On Sun, Nov 9, 2014 at 1:05 AM, ivavok wrote:
> Hi PramodSingh ,
>
> Thank you for the funtion! Sorry I did not mention but the comma is a
> decimal comma not between thousands. So for example the fi
Hi PramodSingh ,
Thank you for the funtion! Sorry I did not mention but the comma is a
decimal comma not between thousands. So for example the first figure should
not be 1575000 but 15750. Sorry I should have told this...How should I
change the funtion please?
However, I would also like to des
Hi ivana,
Please find the attached file as your reference...
On Sat, Nov 8, 2014 at 1:46 PM, ivavok wrote:
> Hi,
>
> I have tried it before too but it does not work. It does not delete "Kč" at
> all...When I run my macro, I get the data in the table attached. "Kč" is
> deleted but spaces are
Hi,
I have tried it before too but it does not work. It does not delete "Kč" at
all...When I run my macro, I get the data in the table attached. "Kč" is
deleted but spaces are kept:( I have to delete each space at the end of the
text in the cell and also between thousands, then it will be a num
Hi
I see there is a space between number and "Kč" so use " Kč" instead.
Cheers !!
On Nov 7, 2014 8:15 PM, "ivavok" wrote:
> Hi,
>
> I would appreciate if you could help me with this macro:
>
> *Columns("C:C").Select*
> *Selection.Replace What:="Kč", Replacement:="", LookAt:=xlPart, _*
> *
Hi,
I would appreciate if you could help me with this macro:
*Columns("C:C").Select*
*Selection.Replace What:="Kč", Replacement:="", LookAt:=xlPart, _*
* SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _*
* ReplaceFormat:=False*
*Selection.Replace What:=" ", Replac
14 matches
Mail list logo