• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Currency value not able to change.

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.

AmountYearMonthISNUMBER ?
9,486.00
2019​
Aug
FALSE​
16,056.90
2019​
Aug
FALSE​
676800.00
2019​
Feb
TRUE​
112000.00
2019​
Feb
TRUE​
 
karthidhamo
eg Your 9,486. has 'something' in front of 'number' ... means this is not number - it looks like number.
One possible solution: eg with =SUBSTITUTE(B5,CHAR(202),"")*1 <<<<<
Screenshot 2020-04-27 at 20.21.47.png
 
Last edited:
An alternative solution. Bring your table into Power Query. Let PQ change the data type (an automatic step unless turned off by the operator). Close and Load back to Excel. File attached.
 

Attachments

  • Files.xlsx.xlsx
    19.7 KB · Views: 2
Back
Top