Login Page - Create Account

Support Board


Date/Time: Wed, 19 Mar 2025 09:47:38 +0000



Request Comma's in Spreadsheet Number format

View Count: 277

[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
[2022-10-19 20:53:50]
John - SC Support - Posts: 38782
There is no support for putting commas in numbers in Sierra Chart.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account