I'm using a custom formula to display thousands with a K, but when I enter a cell value in between thousands (3,500) it rounds it up to 4K. How can I stop this, I believe it's a formula issue?? This is the formula I am using [>=1000]$###0,"K";0$.

Any ideas would be much appreciated!

Thanks in advance,
Coinpie