Getting a cells Number Format.

[HighAndWilder]

I have a cell, K2, with a Number Format of dd/mm/yyyy

When I try to assign this number format to a string variable it comes out as m/d/yyyy

strNF = Range("$K$2").NumberFormat

What am I doing wrong?

Thanks

 

[Phuoc]

Try this:

strNF = Range("$K$2").Text

 

[HighAndWilder]

Try this:

strNF = Range("$K$2").Text

I am after the Number Format not the value in the cell.

 

[abdelfattah]

Number Format of dd/mm/yyyy

you mean Date Format , not Number Format,right?

I am after the Number Format not the value in the cell.

Does work for you?

strNF = Format(Range("$K$2").Value, "dd/mm/yyyy")

 

[Peter_SSs]

What happens if you use this?

strNF = Range("$K$2").NumberFormatLocal

 

[HighAndWilder]

What happens if you use this?

strNF = Range("$K$2").NumberFormatLocal

That works fine Peter.

Thanks

 

[Peter_SSs]

You're welcome. Thanks for the confirmation.