Login Page - Create Account

Support Board


Date/Time: Wed, 19 Mar 2025 14:27:33 +0000



Post From: Request Comma's in Spreadsheet Number format

[2022-10-19 15:43:58]
JohnR - User831573 - Posts: 320
I looked around, but did not find anything to allow me to specify comma's as a separator within a large number. Specifically, I am looking at a column of Volume #'s. It appears I am only allow to choose from the list of formats supplied. Using commas is not one of them and neither is the ability, like in Excell to specify a custom format.

To display As Use this code
12000 12,000 #,###

My issue is looking at large volumes and trying to easily distinguish 8 mil from 80 mil 8000000 80000000 vs 8,000,000 80,000,000 using the second set of formats it is quick and easy to know what I am dealing with. If I get around to more automation, this is not an issue, but in my current level of usage, I need to do a fair amount of things manually / visually as I select symbols to trade.

Please advise if this is possible, and I did not search enough.
JohnR
imagesc SpreadShhet - Comma in number format.jpg / V - Attached On 2022-10-19 15:38:06 UTC - Size: 31.46 KB - 89 views