Can't you just change the cell to text format
makes sense yet TEXT gives lots of suboptions and none of them give the desired result.
I'm pretty sure excel used to be simpler because of less extensive options - I'm talking Office 97/2003 days.
Its a bit like PES - one could either get caught up in all the variables of ML/MC (i.e. google) or one could just play vanilla PES in Exhibition mode (i.e. come here and get a straight answer).