Forum Discussion
cjteti
Feb 28, 2024Copper Contributor
Weird Excel Issue - 0 showing up instead of correct value
Hi, so I've been using excel for a long time and never ran into an issue like this. I have 5 cells. 4 of them show a currency value: C18 - $10,062.25 C19 - $7,435.63 C20 - $2,501.70 C21 - $16,09...
tometaylor
Oct 29, 2024Copper Contributor
cjteti I was having the same issue and the issue was I manually added $ to the values which created a custom field. If you change the source fields to Accounting or Currency it should calculate correctly.