Posted to microsoft.public.excel.programming

Niek Otten Niek Otten is offline

external usenet poster

Posts: 3,440

Application.DecimalSeparator

Hi all,

I use Application.DecimalSeparator in a function to strip characters from a string and leave just a number.
I noticed that, if you have ToolsOptionsInternational, Use system separators checked, this will not be reflected in
Application.DecimalSeparator.
Can anybody tell me what I should use to get that?

Thanks,
--
Kind regards,

Niek Otten

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
difference application.quit & application.close	Pierre via OfficeKB.com[_2_]	Excel Programming	4	November 8th 05 07:55 PM
Application.GetOpenFilename vs Application.Dialogs(xlDialogsOpen)	Paul Martin	Excel Programming	5	August 5th 05 04:44 PM
Replace application.RTD property by Application.RTDServers collect	John.Greenan	Excel Programming	1	July 7th 05 02:05 PM
macro to close excel application other than application.quit	mary	Excel Programming	1	September 14th 04 03:43 PM
Application.DecimalSeparator usage.	Beto[_3_]	Excel Programming	4	March 1st 04 04:29 PM

All times are GMT +1. The time now is 10:02 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us