Search: | |||||

| ||||

Home » Forum » MS Office | RSS Feeds |

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

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.

Related Topics:

- combine number formats
- Number Format
- Formatting a Number
- Formatting number
- Discover Cell Background Color
- Discover line and columm that I selected
- Converting a "Stringed" Number to a Number
- Converting a "Stringed" Number to a Number
- Convert Serial Number to a Date Function
- Summing on varying number of rows in Excel using VBA
- Number crunching
- find the number of working days (monday to firday) between two give
- Problem with random number in java
- How to control number of textboxes according to user input
- Count unique names in listbox & put the number on the userform
- Detecting text vs numbers with an If/Then
- VBA to use unique password using volume serial number
- Count the number of rows on a worksheet, divide the count by 15
- generating random numbers
- Fibonacci and Prime numbers
- convert from number (0-255) to character
- Math function to determine if a number is an int
- Error preallocating sequence numbers. The sequence table information
- Datagrid Display - right align numbers
- Getting the time for the Number of records retrived