Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Matching number formats
I am using an INDEX/MATCH formula and do get a "VALUE NOT AVAILABLE"
response. Both ranges have a "General" format. A [Copy][Paste Special][Formats] does not make the formats match. How can I make them respond to each other? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maximum Number of Cell Formats | Excel Discussion (Misc queries) | |||
number formats default to 2 decimal points when entered so 24 bec. | Excel Discussion (Misc queries) | |||
How do I do conditional formatting on number formats not patterns. | Excel Discussion (Misc queries) | |||
Conditional Number Formats | Excel Discussion (Misc queries) | |||
number formats that allow you to format the appearance of negativ. | Charts and Charting in Excel |