these safe way to do it, would be to change your writing routine
instead of hardcoding the "." you'll need to use a variable.
all nicely provided by Excel..
?application.DecimalSeparator
,
?application.International(xlListSeparator)
;
very consistent.. isnt it? don't worry there's a long way for the
decimal too :)
?application.International(DecimalSeparator)
,
when you want to use replace..
change "." to chr$(11)
change "," to "."
change chr$(11) to ","
not very likely the chr(11) pops up anywhere else in your file...
if your're coding for xl97+ use application.substitute iso replace
as the later was introduced with xl2000
keepITcool
< email : keepitcool chello nl (with @ and .)
< homepage:
http://members.chello.nl/keepitcool
"?B?YmlnIHQ=?=" wrote:
Hi,
My application writes out a text file for use in another software
application which only reads numbers in an English format eg 12,345.67
But I have clients who use a European format eg 12.345,67
So I need to know if there is a funtion I can use to switch all points
(".") to commas (",") and vice-versa, preferably in one easy step.
I know about the Replace function, but AFAIK this only replaces one
substring with another - I need to do two at the same time. Any ideas?
TIA
big t