SOLVED

Perplexed with this numbers formatting....Help Please!!! :)

%3CLINGO-SUB%20id%3D%22lingo-sub-3221865%22%20slang%3D%22en-US%22%3EPerplexed%20with%20this%20numbers%20formatting....Help%20Please!!!%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3221865%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20am%20hoping%20someone%20can%20assist%20with%20this%20dilemma%20for%20which%20I%20am%20faced.%26nbsp%3B%20I%20have%20an%20old%20log%20I%20am%20updating%20for%20my%20institution.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20Column%20C%2C%20Rows%2010-25%20the%20worksheet%20populates%20the%20full%2016%20digit%20number%20entered.%26nbsp%3B%20However%2C%20when%20entering%20the%20number%20in%20Column%20C%2C%20Rows%2030-34%20it%20populates%20in%20the%20Scientific%20format.%26nbsp%3B%20Yet%2C%20the%20formatting%20in%20Column%20C%2C%20Row%2030-34%20is%20the%20same%20as%20the%20formatting%20in%20Column%20C%2C%20Row%2010-25.%26nbsp%3B%20These%20are%20formatted%20as%20Text%20(which%20is%20how%20I'd%20like%20these%20cells%20to%20be%20formatted).%3C%2FP%3E%3CP%3EWould%20someone%20be%20able%20to%20explain%20why%20Excel%20is%20allowing%20for%20the%20full%2016%20digit%20number%20to%20show%20in%20the%20former%2C%20however%2C%20not%20in%20the%20latter%3F%26nbsp%3B%20Also%2C%20if%20someone%20could%20help%20me%20with%20formatting%20the%20cells%20to%20populate%20the%20full%2016%20digit%20number%20as%20text%2C%20it%20would%20be%20greatly%20appreciated.%20These%20cells%20are%20not%20calculated.%3C%2FP%3E%3CP%3EI've%20included%20screen%20shots%20of%20the%20formats%20and%20the%20file%20for%20reference.%3C%2FP%3E%3CP%3EI%20do%20appreciate%20any%20help%20that%20is%20given.%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3221865%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3222384%22%20slang%3D%22en-US%22%3ERe%3A%20Perplexed%20with%20this%20numbers%20formatting....Help%20Please!!!%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3222384%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F432860%22%20target%3D%22_blank%22%3E%40MichaelAntonelli%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20add%20any%20letter%20before%20the%20text%2C%20press%20enter%2C%20then%20remove%20it%3C%2FP%3E%3CP%3Efind%20your%20file%20ready.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3222571%22%20slang%3D%22en-US%22%3ERe%3A%20Perplexed%20with%20this%20numbers%20formatting....Help%20Please!!!%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3222571%22%20slang%3D%22en-US%22%3EHi%20%40JihadAl-Jarady%3CBR%20%2F%3EThank%20you%20for%20replying%20to%20my%20inquiry.%20I%20appreciate%20your%20prompt%20response.%3CBR%20%2F%3EI'm%20not%20sure%20I%20follow%20what%20I%20need%20to%20do%20to%20format%20the%20cells.%20The%20log%20that%20was%20attached%20is%20the%20old%20log.%20I%20am%20in%20need%20of%20how%20to%20perform%20the%20formatting%20to%20a%20new%20worksheet%20that%20I%20developed%20from%20ground%20zero.%20I%20don't%20want%20the%20task%20of%20logging%20the%20number%20to%20the%20cell%20to%20be%20burdensome%20for%20the%20end%20user.%20I%20would%20like%20for%20them%20to%20enter%20the%20number%20as%20they%20see%20it%20on%20their%20paperwork%20and%20continue%20on%20without%20having%20to%20insert%20special%20characters%20to%20reference%20the%20text%20(i.e.%3A%20the%20apostrophe%20before%20the%20number).%3CBR%20%2F%3EWould%20you%20know%20how%20I%20would%20format%20the%20cells%20to%20accomplish%20this%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3224005%22%20slang%3D%22en-US%22%3ERe%3A%20Perplexed%20with%20this%20numbers%20formatting....Help%20Please!!!%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3224005%22%20slang%3D%22en-US%22%3EWhat%20you%20need%20to%20do%20is%20enter%20cell%20editing%20mode%20by%20double%20click%20on%20the%20cell%20C31%20or%20press%20F2%2C%20then%20just%20press%20enter.%3CBR%20%2F%3EFor%20the%20cells%20C32-C34%20you%20need%20to%20change%20the%20format%20from%20Number%20to%20text.%3C%2FLINGO-BODY%3E
Contributor

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.   

6 Replies

Hi @MichaelAntonelli 

 

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?

@MichaelAntonelli 

C31 is recognized as text. Check with ISTEXT() or ISNUMBER().

 

Solution: Goto C31, press F2, press ENTER.

 

best response confirmed by MichaelAntonelli (Contributor)
Solution
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.
@Jihad Al-Jarady. Thank you so very much! You have no idea how much I appreciate your help with this. Thank you thank you thank you!!!!! I hope you have a wonderful day. Please stay healthy and safe.
@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!