SOLVED

Keeping exact numbers (stop rounding/scientific notation)

%3CLINGO-SUB%20id%3D%22lingo-sub-1522244%22%20slang%3D%22en-US%22%3EKeeping%20exact%20numbers%20(stop%20rounding%2Fscientific%20notation)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1522244%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20one%20column%20that%20lists%20various%20receipt%20IDs%20that%20include%20a%20variety%20long%20or%20short%20numbers%20or%20text%20(Example%3A%26nbsp%3B3666979%2FJU%3B%26nbsp%3B20001010905018546%3B%20R00017%2F2020%3B%26nbsp%3B16773...).%20I%20just%20want%20to%20keep%20the%20exact%20number%2Ftext%20within%20cell%20without%20any%20formatting%20changing%20it.%20I've%20tried%20a%20couple%20solutions%20with%20no%20real%20luck%20from%20several%20queries%20online%2C%20I%20keep%20either%20getting%20scientific%20notation%20for%20long%20numbers%20or%20having%20the%20number%20round%20up%20or%20round%20down.%20Changing%20the%20cell%20format%20to%20%22Number%22%20results%20in%20scientific%20notation%20and%20solutions%20for%20that%20say%20to%20change%20the%20format%20to%20%22Text%22%20or%20to%20add%20an%20apostrophe%20in%20front%20of%20it.%20Changing%20the%20format%20of%20the%20cell%20to%20%22Text%22%20results%20in%20the%20number%20rounding%20up%20or%20down%20(ex.%26nbsp%3B20001010905018546%20changes%20to%26nbsp%3B20001010905018540).%26nbsp%3B%20There%20are%20no%20decimals%20places%20involved%2C%20so%20I%20do%20not%20need%20to%20adjust%20the%20decimal%20place%20like%20many%20solutions%20only%20say%20to%20do%20to%20stop%20rounding.%26nbsp%3B%20How%20can%20I%20resolve%20this%20to%20just%20keep%20the%20data%20unchanged%20when%20entered%3F%20My%20other%20columns%20use%20formatting%20the%20way%20I%20need%2C%20so%20this%20is%20the%20only%20column%20that%20I%20cannot%20resolve.%20Any%20help%20would%20be%20appreciated!%20Note%3A%20I'm%20on%20Excel%202016%20for%20Mac.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1522244%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1522360%22%20slang%3D%22en-US%22%3ERe%3A%20Keeping%20exact%20numbers%20(stop%20rounding%2Fscientific%20notation)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1522360%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F728664%22%20target%3D%22_blank%22%3E%40larc91%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETry%20it%20in%20this%20order%3A%3C%2FP%3E%3CP%3E1.%20Delete%20current%20cell%20content.%3C%2FP%3E%3CP%3E2.%20Change%20number%20format%20to%20%22Text%22.%3C%2FP%3E%3CP%3E3.%20Type%20the%20ID%20into%20the%20cell.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1862061%22%20slang%3D%22en-US%22%3ERe%3A%20Keeping%20exact%20numbers%20(stop%20rounding%2Fscientific%20notation)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1862061%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F728664%22%20target%3D%22_blank%22%3E%40larc91%3C%2FA%3E%26nbsp%3BI%20have%20the%20same%20issue.%20I%20have%20tried%20every%20solution%20found%20on%20a%20search%2C%20including%20deleting%20the%20content%20and%20editing%20the%20cell%20format%20to%20text.%20It%20then%20converts%20to%20scientific%20notation.%20I%20need%20the%20full%20number.%20The%20problem%20here%20is%20that%20I%20have%20thousands%20of%20numbers%20in%20excel%20and%20I%20don't%20really%20want%20to%20manually%20type%20all%20of%20them.%20Is%20there%20a%20better%20solution%20to%20stop%20excel%20from%20rounding%20my%20numbers%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I have one column that lists various receipt IDs that include a variety long or short numbers or text (Example: 3666979/JU; 20001010905018546; R00017/2020; 16773...). I just want to keep the exact number/text within cell without any formatting changing it. I've tried a couple solutions with no real luck from several queries online, I keep either getting scientific notation for long numbers or having the number round up or round down. Changing the cell format to "Number" results in scientific notation and solutions for that say to change the format to "Text" or to add an apostrophe in front of it. Changing the format of the cell to "Text" results in the number rounding up or down (ex. 20001010905018546 changes to 20001010905018540).  There are no decimals places involved, so I do not need to adjust the decimal place like many solutions only say to do to stop rounding.  How can I resolve this to just keep the data unchanged when entered? My other columns use formatting the way I need, so this is the only column that I cannot resolve. Any help would be appreciated! Note: I'm on Excel 2016 for Mac. 

2 Replies
Highlighted
Best Response confirmed by larc91 (Occasional Visitor)
Solution

@larc91 

Try it in this order:

1. Delete current cell content.

2. Change number format to "Text".

3. Type the ID into the cell.

 

Highlighted

@larc91 I have the same issue. I have tried every solution found on a search, including deleting the content and editing the cell format to text. It then converts to scientific notation. I need the full number. The problem here is that I have thousands of numbers in excel and I don't really want to manually type all of them. Is there a better solution to stop excel from rounding my numbers?