Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Discover number format

  Asked By: Bakir    Date: Sep 18    Category: MS Office    Views: 980
  

I would like if is possible to discover the format number ?

In this example I don´t get to convert in a currency format.

Example:
1) case = 9.000,00

2) case = 9,000.00

How I discover when I´ve the first format case (#.##0,00) and need to convert to
second format case (#,##0.00)?

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Brendan Smith     Answered On: Sep 18

The NumberFormat property shows you this.

MsgBox ActiveCell.NumberFormat

 
Didn't find what you were looking for? Find more on Discover number format Or get search suggestion and latest updates.




Tagged: