TEXT
Format numbers into report-ready labels.
Why planners need it
Stop pasting raw decimals into commentary. TEXT turns 0.3541 into 08:30 and 0.847 into 84.7% inside a sentence.
Syntax
=TEXT(value, format_code)
Worked example
Build an interval label and an SL string:
=TEXT(time,"hh:mm") → 08:30. =TEXT(sl,"0.0%") → 84.7%.
Join into prose: ="SL was "&TEXT(sl,"0.0%")&" at "&TEXT(t,"hh:mm").
Watch out: TEXT returns text, not a number — don’t feed it back into maths. Format codes are locale-sensitive (hh:mm, 0.0%, #,##0).