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: 946

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

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

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)?



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.