thanks, i am new to UDFs & VBE, i struggled with all of these suggestions,
but ultimately this xformat UDF helped!

"Luke M" wrote:

You can install this short UDF into the VBE first (Alt+F11, Insert - Module,
paste the following code in):

Function XFORMAT(YourCell As Range) As String
XFORMAT = YourCell.NumberFormat
End Function


And then in your workbook, the formula would be:
=XFORMAT(A2)

This will spit out all the information regarding the number formatting. You
will then prb be able to manipulate it using some of the text functions
(LEFT, FIND, MID, etc) to dfetermine what currency is actually being used.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Nipsey Russell" wrote:

situation: a woman i work with pays thousands of invoices a year and records
them in a spreadsheet. When they are in different currencies, she doesn't
record the currency type as a value in a column, but merely formats the cell
as the currency type. I need to be able to eventually convert the amounts
into USD, but i guess i am looking for an interim step to create a column
that takes the formatting and converts to a currency code. I can see at
least 4 different currencies represented. Can anyone provide a formula that
can help me get to my end goal?
thanks!
N