karthidhamo
New Member
HI All:
I just have same currency number format but i don't have the result as same. I tried to find out with isnumber formula it was showed most of the False. I checked all my number format and every think is correct. Pls let me know what is the issue here?
Screen shot below in here first two currency value showing as False and that value not represent during the pivot table making. Pls help this any one how to change it.
I just have same currency number format but i don't have the result as same. I tried to find out with isnumber formula it was showed most of the False. I checked all my number format and every think is correct. Pls let me know what is the issue here?
Screen shot below in here first two currency value showing as False and that value not represent during the pivot table making. Pls help this any one how to change it.
Amount | Year | Month | ISNUMBER ? |
9,486.00 | 2019 | Aug | FALSE |
16,056.90 | 2019 | Aug | FALSE |
676800.00 | 2019 | Feb | TRUE |
112000.00 | 2019 | Feb | TRUE |