How to determine if a format has US dollar sign in Excel
Is there a way to determine if a cell has a US currency set?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanx, and it perfect if I needed a button, but what I need is within the Excel in report format. I created an Excel with jppinto initial formula...
Hope this helps
DetectCurrency.xlsx
Hope this helps
DetectCurrency.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Worked.
Just to make sure, there is no Excel function that does this right (we have to create the function)?
Just to make sure, there is no Excel function that does this right (we have to create the function)?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanx lots
ASKER
thanx
=IF(LEFT(A1,1)="$","True",
jppinto