Feb 28 2022 08:51 AM
Hello,
I am hoping someone can assist with this dilemma for which I am faced. I have an old log I am updating for my institution.
In Column C, Rows 10-25 the worksheet populates the full 16 digit number entered. However, when entering the number in Column C, Rows 30-34 it populates in the Scientific format. Yet, the formatting in Column C, Row 30-34 is the same as the formatting in Column C, Row 10-25. These are formatted as Text (which is how I'd like these cells to be formatted).
Would someone be able to explain why Excel is allowing for the full 16 digit number to show in the former, however, not in the latter? Also, if someone could help me with formatting the cells to populate the full 16 digit number as text, it would be greatly appreciated. These cells are not calculated.
I've included screen shots of the formats and the file for reference.
I do appreciate any help that is given.
Feb 28 2022 10:46 AM
Hi @Michael1105
You can add any letter before the text, press enter, then remove it
find your file ready.
Feb 28 2022 11:07 AM - edited Feb 28 2022 12:52 PM
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?
Feb 28 2022 01:46 PM
C31 is recognized as text. Check with ISTEXT() or ISNUMBER().
Solution: Goto C31, press F2, press ENTER.
Feb 28 2022 09:29 PM
SolutionMar 01 2022 05:42 AM
Mar 01 2022 05:44 AM
Jun 16 2022 05:43 PM
Feb 28 2022 09:29 PM
Solution