Why does =TEXT(16,"TEMP000") return a #VALUE error?
I am trying to get TEMP016 as the result.
I have tried it with other alphanumeric examples, like =TEXT(16, A092000) which should show A092016, and it works fine there.
="TEMP" & TEXT(16; "000")
="TEMP"&text(A2;"000")&"A"
Then ask at an Excel forum, not here. A web search will find one.thatengineer wrote:Yes I use Excel 2013.
It doesn't in Calc. It returns Err:502 (Invalid argument). TEMP000 is not a valid numeric format code in Calc.thatengineer wrote:Why does =TEXT(16,"TEMP000") return a #VALUE error?
You can use these forumulas in Calc to get TEMP016A as the result. I don't know if they will work in Excel.thatengineer wrote:I'm trying to get in sequence TEMP016A, TEMP017A, TEMP018A...
TEXT is a function, not a operator.thatengineer wrote:TEXT Operator In Excel
Users browsing this forum: No registered users and 2 guests