Setting Range.NumbeFormat(Local) on non-English Office installations

[rdilipk]

<code>On this page:
http://msdn.microsoft.com/en-us/library/aa224873(v=office.11).aspx


The example for NumberFormat goes like this:


Worksheets("Sheet1").Range("A17").NumberFormat = "General"


However the string "General" seems incorrect when you have installed a non-English Microsoft Office version. That line above fails by raising an exception.


What is the correct way to set this property in a language-agnostic fashion?


Note: I am interested only in setting that one particular value
</code>

 

[Marcelo Branco]

<CODE>On this page:
http://msdn.microsoft.com/en-us/library/aa224873(v=office.11).aspx


The example for NumberFormat goes like this:


Worksheets("Sheet1").Range("A17").NumberFormat = "General"


However the string "General" seems incorrect when you have installed a non-English Microsoft Office version. That line above fails by raising an exception.


What is the correct way to set this property in a language-agnostic fashion?


Note: I am interested only in setting that one particular value
</CODE>

It worked perfectly in my Excel 2007 portuguese version.

Let me ask: is there in the Workbook a sheet named Sheet1?

M.

 

[rdilipk]

It worked perfectly in my Excel 2007 portuguese version.

Let me ask: is there in the Workbook a sheet named Sheet1?

M.

I just copied that line from the MSDN site. My actual code has a properly constructed range object. I do:

Range.NumberFormat = "General"

This fails on a Chinese language Office installation. (unable to set NumberFormat property or something like that)

 

[rdilipk]

It worked perfectly in my Excel 2007 portuguese version.

Let me ask: is there in the Workbook a sheet named Sheet1?

M.

Other people have posted about it too:
http://www.teachexcel.com/excel-help/excel-how-to.php?i=162960

I just can't find a solution to it yet.

 

[Marcelo Branco]

I just copied that line from the MSDN site. My actual code has a properly constructed range object. I do:

Range.NumberFormat = "General"

This fails on a Chinese language Office installation. (unable to set NumberFormat property or something like that)

Try

Range("A1").NumberFormat = "General"

M.

 

[Rick Rothstein]

Assuming every cell on the entire sheet has not been formatted differently from General, you could just let VB figure it out for you automatically...

Range("A1").NumberFormat = Cells(Rows.Count, Columns.Count).NumberFormat

 

[rdilipk]

Try

Range("A1").NumberFormat = "General"

M.

I think I simplified my example too much. By Range.NumberFormat I simply meant that I have a properly constructed range object on which I call the NumberFormat property.

anyway, I found a solution to my problem. The correct way to do it in a language-agnostic way is to use the return value from:

Application.International(xlGeneralFormatName)

Thanks to:
http://www.excelforum.com/excel-pro...cel-2010-ticklabels-numberformat-problem.html

 

[Marcelo Branco]

Thanks to:
http://www.excelforum.com/excel-pro...cel-2010-ticklabels-numberformat-problem.html

I can not access this link. Could you re-post the link?

M.

 

[rdilipk]

I can not access this link. Could you re-post the link?

M.

If I post this link this forum is replacing 3 letters in there with ***. Just replace those 3 asterisks with the letters J, A and P.

http://www.excelforum.com/excel-pro...cel-2010-ticklabels-numberformat-problem.html