Support Board

Date/Time: Sun, 06 Oct 2024 09:55:54 +0000

Post From: Migrating my old spreadsheets to the new Spreadsheet format: Trying to convert Number to Text i

[2014-11-23 02:49:49] Link To Thread - Link To Post [Go To First Post]
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.