Convert from dot to comma - Listvalues - Not a question

XL-Dennis

Well-known Member
Joined
Jul 27, 2002
Messages
1,920
On Error Goto Exit
This message was edited by XL-Dennis on 2002-11-14 17:10
 

Some videos you may like

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Mark W.

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,654
Take a look at the Text to Column wizard's Step 3 of 3 [ Advanced... ] button.
 

Jack in the UK

Well-known Member
Joined
Feb 16, 2002
Messages
3,215
Hi Mark its Jack

Can i say ive sat here for about ten minutes thinking and thats a discrace of a responce, VERY RUDE dont you agree? Address Dennis you know he is second language English and is from Sweeden, thats a little over the top top dont you think??

Dennis did not post a question it was a post to offer help as many of i do, a FREE GIVE AWAY, no where did Dennis say hes right or this is the ONLY solution

Mark, how would you like it if itagged every single post of your and did this and distroyed you work and kind offer of help - this would be fair and reasonable would it not?

Come on thats a bit of a slap to Dennis!

Kindest regards

JITUK
 

Jack in the UK

Well-known Member
Joined
Feb 16, 2002
Messages
3,215

ADVERTISEMENT

Hi Dennis its Jack ????

Ok my friend you have deleted you post - little i can say i did see Marks comments amd you had not posted at that time, thus my responce, hope you dont mind

What gets me is Mark is MVP and simply thats a discrace..

Lie i said maybe i should track his work and be sarcastic and disrespect his posts, but then again im not that petty

Sorry Dennis - what can i do?

SOME MVP reflect poorly

JITUK
 

dantb

Active Member
Joined
Mar 20, 2002
Messages
358
Well I would like to thank you XL-Dennis,lucky I saved it before you deleted. Thanks again Dan
 

XL-Dennis

Well-known Member
Joined
Jul 27, 2002
Messages
1,920

ADVERTISEMENT


This message was edited by XL-Dennis on 2002-11-14 18:48
 

dantb

Active Member
Joined
Mar 20, 2002
Messages
358
Sometimes you have to take the good with the bad. All in here are not experts and those of us that are not, appreciate all the help we can get. Sad the competition is so high, because so many are in need and interested in learning anything they can. Dan
 

Jack in the UK

Well-known Member
Joined
Feb 16, 2002
Messages
3,215
Hi Dennis

Do what you most - but Mark has done this before he ont answer ive tried before he just hide before has ignored PM and from pals of mine to. Iv had this now 5 or 6 times, just his way. People do notice and i get loads of Pm and emails on this subject, and all sorts

Ive had enough too, ill post in questions forumn and see ill address ALL MVP as you know i know all of them and se if they can add.

What else can i do? I get so many email saying guys ive never hurd of showing support towards me and and i thank them kindly from their warm comments but some [not many] MVP do cross the line

JITUK
 

Mark W.

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,654
What a bunch of cry babies! Grow up!

I was merely prompting Dennis to look at Excel's built-in functionality.

A single VBA statement can be created by simply by using the macro recorder...

Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _
Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _
:=Array(1, 1), DecimalSeparator:=",", ThousandsSeparator:="."
This message was edited by Mark W. on 2002-11-14 09:51
 

Watch MrExcel Video

Forum statistics

Threads
1,122,804
Messages
5,598,151
Members
414,214
Latest member
marketingnumbersguy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top