Posted to microsoft.public.excel.programming

Charlotte E.[_3_] Charlotte E.[_3_] is offline

external usenet poster

Posts: 160

Converting NumberFormatLocal to NumberFormat

Hi Guys,

I need to convert strings containing local numberformats into English
numberformats.

And, currently, I'm using a cell as 'middleman' :-)

Range("A1").NumberFormatLocal = Local_Format_Name
English_Format_Name = Range("A1").NumberFormat

Is it possible to do this convert without using a worksheet at all?

CE

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
Excel automation through .NET Interop: NumberFormat property looks like NumberFormatLocal	martin durtschi	Excel Programming	4	May 13th 14 07:39 PM
Cell Format Function "NumberFormatLocal" in VBA	ppt_puppet	Excel Programming	1	January 4th 10 06:30 AM
NumberFormat vs. NumberFormatLocal	[email protected]	Excel Programming	2	March 10th 06 06:58 PM
NumberFormat vs NumberFormatLocal	Martin V	Excel Programming	1	September 3rd 04 12:51 AM
Copy with NumberFormatLocal included	Patrick Molloy[_3_]	Excel Programming	0	July 17th 03 07:46 AM

All times are GMT +1. The time now is 01:36 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us