Forum Discussion
Perplexed with this numbers formatting....Help Please!!! :)
- What you need to do is enter cell editing mode by double click on the cell C31 or press F2, then just press enter.
For the cells C32-C34 you need to change the format from Number to text.
Hi Michael1105
You can add any letter before the text, press enter, then remove it
find your file ready.
Hi Jihad Al-Jarady
Thank you for replying to my inquiry. I appreciate your prompt response.
I'm not sure I follow what I need to do to format the cells. The log that was attached is the old log. I am in need of how to perform the formatting to a new worksheet that I developed from ground zero. I don't want the task of logging the number to the cell to be burdensome for the end user. I would like for them to enter the number as they see it on their paperwork and continue on without having to insert special characters to reference the text (i.e.: the apostrophe before the number).
Would you know how I would format the cells to accomplish this?- What you need to do is enter cell editing mode by double click on the cell C31 or press F2, then just press enter.
For the cells C32-C34 you need to change the format from Number to text.- Hi! Pls check my question: https://techcommunity.microsoft.com/t5/excel/please-help-me-with-formula-in-excel/m-p/3518804
C31 is recognized as text. Check with ISTEXT() or ISNUMBER().
Solution: Goto C31, press F2, press ENTER.
- Detlef_Lewin. Thank you so much for replying to my post. I appreciate you taking your time to help me. I used Jihad's suggestion and it worked perfectly. Thanks again!
