Support Board
Date/Time: Fri, 29 Nov 2024 18:28:07 +0000
Post From: TEXT(Value, Format)
| [2023-01-21 17:21:24] |
| User719206 - Posts: 93 |
|
thanks tomgilb you formula is working but i'm limited, if the number has more than 11 character the cell is blank. john i m obligated to switch it in text because the cell j 102 text tag looks to work only with text format. I have to find a solution to switch a big number as 562536548547856212536585 like if it was text, a functiun witch do the same job that "" => "562536548547856212536585". OR get the ability to select "text" in the different number format. I have another problem , if i write even manually 99999999999999 in a cell , the cell gona display 10270005887756666 (it's an exemple) , something go wrong i don't know why , maybe the 2 probleme are linked. I attached my spreadsheet , I saw that you asked it to someone who had the same bug. Date Time Of Last Edit: 2023-01-23 15:07:15
|
Private File |