Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to refer to a cell format code?
Hi!
I have a huge amount of different money values in diffenet cells, and I need to separate/sort them according to the currency. The problem is that the currency has been defined from the cell format menu(Format cell -custom and # ##0,00\ "AUD"). If I use the FIND or SEARCH tools, they won't find the text AUD because it is not typed in to the cell in a "regular" way. So I'm asking if someone knows how to make a reference to the "AUD" part of the cell format code, so that I could sort those currencies. If someone knows some way to do this sorting, I would appreciate, if someone could help me. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) | |||
Format a cell with numbers and user defined text | Excel Discussion (Misc queries) | |||
Custom format that shows blank cell if another cell is empty | Excel Discussion (Misc queries) | |||
Make Change Case in Excel a format rather than formula | Excel Worksheet Functions | |||
Format spreadsheet so no input allowed if certain cell is =<0 | Excel Worksheet Functions |