Issue with cell referencing

Occasional Visitor

I am working on a project dashboard in MS Excel.
I needed to use the text function, but there is an issue; the original cell value doesn't change into the format cell specified and returns the value one. 
This issue has been delaying my progress for the last couple of days. 
Can anyone please help me in resolving this?Screenshot (66).pngScreenshot (67).png

Thank You

1 Reply
Change the number format of Y27 to Text, and then if necessary reenter 0.0%.