Support Board
Date/Time: Sat, 21 Dec 2024 13:12:48 +0000
Migrating my old spreadsheets to the new Spreadsheet format: Trying to convert Number to Text i
View Count: 1084
| [2014-11-23 02:49:49] |
| User641744 - Posts: 4 |
|
I am trying to find a way to convert numeric values to text. I found the VALUE(text) function which converts text into a number. But I can't find a function to go the other way (number to text). Am I missing it? or is this not supported? Background: ----------- I have been using the spreadsheet function for some time now in order to build SQL Insert strings that I load into a MYSQL database where I conduct historical detailed analysis. I see the old concatenate symbol (&) has been replaced with the new CONCATENATE function. I've made the switch to CONCATENATE in my spreadsheets but am having issues with the mix of text and numeric fields in the CONCATENATE. It displays #VALUE! when I try to include a cell reference which contains a number. I see in the documentation that everything needs to be in text format in order for CONCATENATE to work. I just can't find a way to convert the numbers to text. Thanks for any help you can give. |
| [2014-11-24 17:38:04] |
| |
|
We are reviewing this and we will add the necessary functionality to make sure everything works properly for what you are doing.
Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2014-11-26 00:52:07] |
| |
|
We will be adding a NUMBERTOTEXT function. We will try to get this out next week. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2014-11-26 00:52:27
|
| [2014-12-23 23:36:46] |
| User641744 - Posts: 4 |
|
Hello, Did this get released yet? I just downloaded version 1220 but can't get this to work yet. If it has been released, is there anything special I need to do to use it with existing (new format) spreadsheets? Thanks. |
| [2014-12-24 21:04:06] |
| |
|
Yes this has been released and the function is TEXT: https://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetFunctions.html Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2014-12-24 23:10:48] |
| User641744 - Posts: 4 |
|
Thanks, Found it. But... it isn't handling large number values as expected. Any value 6 digits or larger seems to be rendered in exponential form. For example, =Text(20141225) is returning "2.01412e07" Can it just return the straight text ("20141225")? Thanks |
| [2014-12-24 23:59:24] |
| |
|
We are checking on this.
Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to 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: