Login Page - Create Account

Support Board


Date/Time: Fri, 29 Nov 2024 18:41:07 +0000



Post From: TEXT(Value, Format)

[2023-01-19 18:08:26]
User719206 - Posts: 93
hello , i want to spend some numeric spreadsheet value ,in test tag , whan I backestest to get some information .
i need to translate numeric value in text value. i thought to use TEXT(Value, Format) functiun that is suposed to do it.

But it seems that it's only work if i write manualy the numeric value , if I write TEXT(5, Format) i get 5 in texte value ,
but if I write TEXT(C5, Format) With the c5 cell value of 5 , I get C5. the name of the cell not the value.

maybe i did something wrong.
Date Time Of Last Edit: 2023-01-19 21:24:28