If Cells.value match this format "0,000.00" then ...

Hi everyone,

I would like to check if the value within a cell is formated as follows "0,000.00"

Example: Range("A1").value = 1,098.19 -> it would return true.

Do you have any idea?

Thanks in advance for your help,
-Phil

Awesome, you put me on the right track !

Please Login or Register  to view this content.

I just had to change "0,000.00" for "#,##0.00"

Thanks you so much again