Excell Quick Question Function Large Exponents Precise Numbers ' Function Error?

%3CLINGO-SUB%20id%3D%22lingo-sub-1458203%22%20slang%3D%22en-US%22%3EExcell%20Quick%20Question%20Function%20Large%20Exponents%20Precise%20Numbers%20'%20Function%20Error%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1458203%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20so%20I%20have%20become%20very%20bored%20and%20started%20to%20calculate%20number%20formats%20using%20Standard%20Nano%20Time%20and%20ran%20into%20small%20problems%20while%20attempting%20to%20convert%20precise%20numbers%20down%20to%20exact%20decimal%20forums%20based%20upon%20an%20Excell%20Missconfiguration%20and%20am%20unsure%20as%20to%20how%20to%20fix%20it%20correctly.%3C%2FP%3E%3CP%3E%3CFONT%3E%3CA%20href%3D%22https%3A%2F%2Fwww.techonthenet.com%2Funicode%2Fchart.php%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.techonthenet.com%2Funicode%2Fchart.php%3C%2FA%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3E%5E%5EHere%5E%5E%20is%20my%20source%20I%20had%20used%20to%20look%20up%20the%20apostrophe%20and%20what%20it%20is%20used%20for%20as%20I%20do%20recall%20being%20taught%20to%20use%20'%20(or%20apos)%20for%20numbers%20that%20would%20round%20while%20in%20college%20to%20complete%20functions%20but%20am%20unable%20to%20receive%20a%20correct%20function%20return%20using%20the%20'%20with%20any%20function%3F%20I%20have%20reinstalled%20and%20checked%20Options%20for%20possible%20solutions%20and%20am%20unsure%20if%20I%20am%20overlooking%20the%20solution%20or%20what%20I%20should%20utilize%20to%20allow%20Excell%20to%20function%20using%20the%20'%20Unicode%20character.%20I%20do%20appreciate%20any%20responses%20as%20I%20have%20lots%20of%20criteria%20I%20do%20have%20to%20double%20check%20since%20I%20had%20noticed%20since%20working%20with%20complex%20conversion%20spectrums%20from%20double%20negative%20intigers%20in%20form%20of%20%22bi-monomial%22%20forum%20and%20converting%20between%20Positive%20and%20Negative%20Exponents%20representing%20binary%20forum%20to%20complete%20time%20scales%20and%20conversions%20between%20offsets%20of%20decimal%20places%20that%20are%20recalculated%20back%20to%20standard%20offsets%20from%20%2B%20and%20-%20Exponents%20for%20a%20variable%20rate%20or%20missing%20variable%20to%20utilze%20spectrum%20reverse%20implantation%20methods%20of%20finding%20more%20missing%20variable%20rates%20to%20complete%20offset%20conversions%26nbsp%3B%20at%20a%20double%20negative%20rate%20that%20may%20be%20positive%20or%20negative%3Bas%20I%20have%20been%20working%20with%20quantum%20and%20infinite%20numbers%20to%20recalculate%20missing%20timescales%20between%202%2064ths%20from%20standard%20Nano%20set%20time%20scales%20and%20a%20full%20100%20time%20scale%20fixed%20variable%20rate%20with%20a%20timescale%20%3D%20and%20congruent%20as%20well%20as%20true%20between%20both%20as%20well%20as%20the%20missing%20amount%20of%20time%20from%20Standard%20set%20Nano%20to%20a%20newly%20introduced%20%22theory%22%20I%20am%20attempting%20to%20conclude%20as%20factual%20information%20to%20change%20standard%20Nano%20seconds%20time%20intervals%20on%20the%20planet.%26nbsp%3B%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3EWhat%20can%20I%20change%20to%20Allow%20the%20'%20to%20Function%20with%20Excell%20Functions%3F%3C%2FFONT%3E%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3EU%2B0027%3C%2FTD%3E%3CTD%3E'%3C%2FTD%3E%3CTD%3E39%3C%2FTD%3E%3CTD%3E27%3C%2FTD%3E%3CTD%3E047%3C%2FTD%3E%3CTD%3E'%3C%2FTD%3E%3CTD%3E%5Cu0027%3C%2FTD%3E%3CTD%3E27%3C%2FTD%3E%3CTD%3EApostrophe%2FSingle%20quote%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1459318%22%20slang%3D%22en-US%22%3ERe%3A%20Excell%20Quick%20Question%20Function%20Large%20Exponents%20Precise%20Numbers%20'%20Function%20Error%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1459318%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F697234%22%20target%3D%22_blank%22%3E%40XxEarthManxX%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHello!%20You've%20posted%20your%20question%20in%20the%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FCommunity-Discussion%2Fbd-p%2FCommunityQuestions%22%20target%3D%22_blank%22%3ECommunity%20Discussion%20space%3C%2FA%3E%2C%20which%20is%20intended%20for%20discussion%20around%20the%20Tech%20Community%20website%20itself%2C%20not%20product%20questions.%20I'm%20moving%20your%20question%20to%20the%20%5B%23%24dp5%5D%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2Fbd-p%2FExcelGeneral%22%20target%3D%22_blank%22%3EExcel%20space%3C%2FA%3E%20-%20please%20post%20Excel%20questions%20here%20in%20the%20future.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1460216%22%20slang%3D%22en-US%22%3ERe%3A%20Excell%20Quick%20Question%20Function%20Large%20Exponents%20Precise%20Numbers%20'%20Function%20Error%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1460216%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F41707%22%20target%3D%22_blank%22%3E%40Eric%20Starker%3C%2FA%3EThanks%20as%20I%20was%20having%20issues%20looking%20for%20threads%20as%20a%20newbie%20to%20the%20community%20after%20setting%20my%20profile%20up.%20I%20thought%20that%20I%20had%20the%20right%20one%20as%20before%20I%20checked%20threads%20for%20similar%20posts%20that%20may%20have%20had%20my%20answer%20It%20had%20mentioned%20Microsoft%20Excell.%20I%20do%20apologize%20and%20thanks%20for%20redirecting%2Freposting!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1460251%22%20slang%3D%22en-US%22%3ERe%3A%20Excell%20Quick%20Question%20Function%20Large%20Exponents%20Precise%20Numbers%20'%20Function%20Error%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1460251%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Excell-Option-Found.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F198507iEFC6D1079D2BAB1C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Excell-Option-Found.PNG%22%20alt%3D%22Excell-Option-Found.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20did%20manage%20to%20correct%20my%20Issue%20as%20I%20did%20overlook%20the%20option%20in%20formulas%3B%20Thanks%20however%20in%20reguards%20to%20my%20topic%20redirecting%20my%20issue%20as%20it%20was%20a%20simple%20one!%20im%20sure%20I%20will%20have%20more%20questions%20in%20the%20furture.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1468456%22%20slang%3D%22en-US%22%3ERe%3A%20Excell%20Quick%20Question%20Function%20Large%20Exponents%20Precise%20Numbers%20'%20Function%20Error%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1468456%22%20slang%3D%22en-US%22%3E%3CP%3EIt%20Looks%20as%20if%20my%20error%20has%20occurred%20again%20as%20I%20was%20able%20to%20use%20functions%20with%20an%20'%20but%20am%20unable%20to%20again.%20I%20am%20puzzled%20as%20to%20why%20it%20had%20corrected%20itself%20then%20went%20back%20to%20the%20same%20error%20from%20the%20simple%20settings%20checkbox.%20I%20am%20unsure%20to%20as%20if%20it%20has%20to%20deal%20with%20java%20and%20using%20text%20forum%20of%20large%20number%20targets%20targeting%20command%20java%20function%20strings%20for%20quick%20indexing%20as%20I%20do%20run%20a%20different%20java%20as%20a%20system%20variable%20to%20execute%20and%20run%20different%20%22modified%20java%20functions%22%20under%20an%20applet%20I%20that%20allows%20unknown%20source%20for%20calculations%20and%20source%20development%20of%20toolchains%20and%20array%20editors%20that%20will%20eventually%20be%20broken%20away%20from%20java%20source%20ect.%20I%20run%20it%20under%20an%20applet%20to%20ensure%20I%20do%20not%20break%20policy%20as%20I%20also%20recieve%20an%20error%20for%20compiling%20by%20keeping%20modified%20source%20as%20system%20variable%20to%20prevent%20server%20errors%20from%20origin%20untouched%20java.%20As%20I%20do%20have%20a%20text%20file%20I%20will%20upload%20explain%20my%20Pc%20and%20slight%20modifications%20using%20java%20source%20for%20new%20development%20of%20a%20PC%20once%20calculating%20my%20numbers%20for%20an%20advanced%20PC%20using%20an%20alogithium%20condensing%20large%20scale%20numbers%20on%20a%20repeating%20binary%20system%20to%20emmulate%20a%20memory%20file%20for%20compression%20of%20large%20files%20or%20System%20as%20Subsystem%20for%20main%20cached%20system%20invokes.%20%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22CachedMemory.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F199056iC6F10D7A5DDA11A3%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22CachedMemory.PNG%22%20alt%3D%22CachedMemory.PNG%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Emmulated%20Mem%20Out%20of%20Mem%20Current%20System%20Running.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F199054i5A2D1B8F9A8AAF90%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Emmulated%20Mem%20Out%20of%20Mem%20Current%20System%20Running.PNG%22%20alt%3D%22Emmulated%20Mem%20Out%20of%20Mem%20Current%20System%20Running.PNG%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22MirosoftQuestion.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F199055i15C8B5D1AF2AC63A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22MirosoftQuestion.PNG%22%20alt%3D%22MirosoftQuestion.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1486977%22%20slang%3D%22en-US%22%3ERe%3A%20Excell%20Quick%20Question%20Function%20Large%20Exponents%20Precise%20Numbers%20'%20Function%20Error%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1486977%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20some%20cases%2C%20you%20may%20be%20able%20to%20prevent%20rounding%20errors%20from%20affecting%20your%20work%20by%20using%20the%20**Precision%20as%20displayed%20**option.%20This%20option%20forces%20the%20value%20of%20each%20number%20in%20the%20worksheet%20to%20be%20the%20displayed%20value.%20To%20turn%20on%20this%20option%2C%20follow%20these%20steps.%3C%2FP%3E%3CP%3EOn%20the%20File%20menu%2C%20click%20Options%2C%20and%20then%20click%20the%20Advanced%20category.%3C%2FP%3E%3CP%3EIn%20the%20When%20calculating%20this%20workbook%20section%2C%20select%20the%20workbook%20that%20you%20want%2C%20and%20then%20select%20the%20Set%20precision%20as%20displayed%20check%20box.%3C%2FP%3E%3CP%3EFor%20example%2C%20if%20you%20choose%20a%20number%20format%20that%20shows%20two%20decimal%20places%2C%20and%20then%20you%20turn%20on%20the%20Precision%20as%20displayed%20option%2C%20all%20accuracy%20beyond%20two%20decimal%20places%20is%20lost%20when%20you%20save%20your%20workbook.%20This%20option%20affects%20the%20active%20workbook%20including%20all%20worksheets.%20You%20cannot%20undo%20this%3C%2FP%3E%3CP%3Eoption%20and%20recover%20the%20lost%20data.%20We%20recommend%20that%20you%20save%20your%20workbook%20before%20you%20enable%20this%20option.%3C%2FP%3E%3CP%3ERepeating%20binary%20numbers%20and%20calculations%20that%20have%20near-zero%20results%3C%2FP%3E%3CP%3EAnother%20confusing%20problem%20that%20affects%20the%20storage%20of%20floating%20point%20numbers%20in%20binary%20format%20is%20that%20some%20numbers%20that%20are%20finite%2C%20non-repeating%20numbers%20in%20decimal%20base%2010%2C%20are%20infinite%2C%20repeating%20numbers%20in%20binary.%20The%20most%20common%20example%20of%20this%20is%20the%20value%200.1%20and%20its%20variations.%20Although%20these%20numbers%20can%20be%20represented%20perfectly%20in%20base%2010%2C%20the%20same%20number%20in%20binary%20format%20becomes%20the%20following%20repeating%20binary%20number%20when%20it%20is%20stored%20in%20the%20mantissa%3A%3C%2FP%3E%3CP%3E000110011001100110011%20(and%20so%20on)%3C%2FP%3E%3CP%3EThe%20IEEE%20754%20specification%20makes%20no%20special%20allowance%20for%20any%20number.%20It%20stores%20what%20it%20can%20in%20the%20mantissa%20and%20truncates%20the%20rest.%20This%20results%20in%20an%20error%20of%20about%20-2.8E-17%2C%20or%200.000000000000000028%20when%20it%20is%20stored.%3C%2FP%3E%3CP%3EEven%20common%20decimal%20fractions%2C%20such%20as%20decimal%200.0001%2C%20cannot%20be%20represented%20exactly%20in%20binary.%20(0.0001%20is%20a%20repeating%20binary%20fraction%20that%20has%20a%20period%20of%20104%20bits).%20This%20is%20similar%20to%20why%20the%20fraction%201%2F3%20cannot%20be%20exactly%20represented%20in%20decimal%20(a%20repeating%200.33333333333333333333).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1535027%22%20slang%3D%22en-US%22%3ERe%3A%20Excell%20Quick%20Question%20Function%20Large%20Exponents%20Precise%20Numbers%20'%20Function%20Error%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1535027%22%20slang%3D%22en-US%22%3EThanks%20as%20I%20Did%20Try%20That%20as%20it%20still%20does%20round%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2FD6RZPJr4JlI%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fyoutu.be%2FD6RZPJr4JlI%3C%2FA%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hi so I have become very bored and started to calculate number formats using Standard Nano Time and ran into small problems while attempting to convert precise numbers down to exact decimal forums based upon an Excell Missconfiguration and am unsure as to how to fix it correctly.

https://www.techonthenet.com/unicode/chart.php

^^Here^^ is my source I had used to look up the apostrophe and what it is used for as I do recall being taught to use ' (or apos) for numbers that would round while in college to complete functions but am unable to receive a correct function return using the ' with any function? I have reinstalled and checked Options for possible solutions and am unsure if I am overlooking the solution or what I should utilize to allow Excell to function using the ' Unicode character. I do appreciate any responses as I have lots of criteria I do have to double check since I had noticed since working with complex conversion spectrums from double negative intigers in form of "bi-monomial" forum and converting between Positive and Negative Exponents representing binary forum to complete time scales and conversions between offsets of decimal places that are recalculated back to standard offsets from + and - Exponents for a variable rate or missing variable to utilze spectrum reverse implantation methods of finding more missing variable rates to complete offset conversions  at a double negative rate that may be positive or negative;as I have been working with quantum and infinite numbers to recalculate missing timescales between 2 64ths from standard Nano set time scales and a full 100 time scale fixed variable rate with a timescale = and congruent as well as true between both as well as the missing amount of time from Standard set Nano to a newly introduced "theory" I am attempting to conclude as factual information to change standard Nano seconds time intervals on the planet. 

What can I change to Allow the ' to Function with Excell Functions?

U+0027'3927047'\u002727Apostrophe/Single quote

 

 

6 Replies
Highlighted

@XxEarthManxX 

Hello! You've posted your question in the Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Excel space - please post Excel questions here in the future. 

Highlighted

@Eric StarkerThanks as I was having issues looking for threads as a newbie to the community after setting my profile up. I thought that I had the right one as before I checked threads for similar posts that may have had my answer It had mentioned Microsoft Excell. I do apologize and thanks for redirecting/reposting!

Highlighted

Excell-Option-Found.PNG

I did manage to correct my Issue as I did overlook the option in formulas; Thanks however in reguards to my topic redirecting my issue as it was a simple one! im sure I will have more questions in the furture.

Highlighted

It Looks as if my error has occurred again as I was able to use functions with an ' but am unable to again. I am puzzled as to why it had corrected itself then went back to the same error from the simple settings checkbox. I am unsure to as if it has to deal with java and using text forum of large number targets targeting command java function strings for quick indexing as I do run a different java as a system variable to execute and run different "modified java functions" under an applet I that allows unknown source for calculations and source development of toolchains and array editors that will eventually be broken away from java source ect. I run it under an applet to ensure I do not break policy as I also recieve an error for compiling by keeping modified source as system variable to prevent server errors from origin untouched java. As I do have a text file I will upload explain my Pc and slight modifications using java source for new development of a PC once calculating my numbers for an advanced PC using an alogithium condensing large scale numbers on a repeating binary system to emmulate a memory file for compression of large files or System as Subsystem for main cached system invokes.  

 

 

CachedMemory.PNGEmmulated Mem Out of Mem Current System Running.PNGMirosoftQuestion.PNG

Highlighted

In some cases, you may be able to prevent rounding errors from affecting your work by using the **Precision as displayed **option. This option forces the value of each number in the worksheet to be the displayed value. To turn on this option, follow these steps.

On the File menu, click Options, and then click the Advanced category.

In the When calculating this workbook section, select the workbook that you want, and then select the Set precision as displayed check box.

For example, if you choose a number format that shows two decimal places, and then you turn on the Precision as displayed option, all accuracy beyond two decimal places is lost when you save your workbook. This option affects the active workbook including all worksheets. You cannot undo this

option and recover the lost data. We recommend that you save your workbook before you enable this option.

Repeating binary numbers and calculations that have near-zero results

Another confusing problem that affects the storage of floating point numbers in binary format is that some numbers that are finite, non-repeating numbers in decimal base 10, are infinite, repeating numbers in binary. The most common example of this is the value 0.1 and its variations. Although these numbers can be represented perfectly in base 10, the same number in binary format becomes the following repeating binary number when it is stored in the mantissa:

000110011001100110011 (and so on)

The IEEE 754 specification makes no special allowance for any number. It stores what it can in the mantissa and truncates the rest. This results in an error of about -2.8E-17, or 0.000000000000000028 when it is stored.

Even common decimal fractions, such as decimal 0.0001, cannot be represented exactly in binary. (0.0001 is a repeating binary fraction that has a period of 104 bits). This is similar to why the fraction 1/3 cannot be exactly represented in decimal (a repeating 0.33333333333333333333).

Highlighted