msuresh
03-19-2012, 02:58 AM
Hi,
I am trying to change a cells display format through custom format option in a workbook. It works like this --a macro will change the target cell's display based on adjacent cells value.
In attached model in Cell “H9” has a value of 2000. Its adjacent cell has a text as “LTM”. By using a macro code I want to change the display format of H9 as LTM. But macro is taking “M” in “LTM” as month for the year 2000 and changing display format as “LT6”.
Please help me how to avoid excel reading “M” as month.
Advance Thanks,
Suresh
I am trying to change a cells display format through custom format option in a workbook. It works like this --a macro will change the target cell's display based on adjacent cells value.
In attached model in Cell “H9” has a value of 2000. Its adjacent cell has a text as “LTM”. By using a macro code I want to change the display format of H9 as LTM. But macro is taking “M” in “LTM” as month for the year 2000 and changing display format as “LT6”.
Please help me how to avoid excel reading “M” as month.
Advance Thanks,
Suresh