Support Board

Date/Time: Fri, 26 Apr 2024 22:06:30 +0000

Post From: TEXT(Value, Format)

[2023-01-21 17:21:24] Link To Thread - Link To Post [Go To First Post]
User719206 - Posts: 92
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