Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello everyone, this is rather an easy question but i am not being able to solve this.
I have a table, where my values are being displayed as this "$58395" but i would like to have them as this "$58,3K". How can i do that?
the format pattern right now looks like this: #.##0 €;-#.##0 € . I played around with it but i just dont get it.
thanks
use num()
Regards,
Prashant Sangle
Try
=Money('$58395'/1000, '$#,##0.0K')