• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Subtraction of two digits of more than 15 digits

Hany ali

Member
hello every one
i want your Help ,how to Subtract Number from another and both of them it contains More than 15 Digits ,for Example
1100848020058807-1100848020058800 = 7
 

Attachments

Hany ali

Member
thanks alot
Well done, always creative, generous professor -you have all my love and respect
 
Last edited:

Hui

Excel Ninja
Staff member
I'm not sure what you mean as I can add numbers to them
63531

Did you save it as a Macro enabled file and open it with Macro's Enabled

Also with numbers larger than 15v digits put a single ' at the front
eg: '1234567890123456789
 

Hany ali

Member
thanks alot for Your Replay me, as you see in the photo ,i make the file as XLSM ,and i put elso asingle ' at the front
i want to see the result ,Not Correct
 

Attachments

Hany ali

Member
Thank you very much and very sorry for your tiredness
And indeed at the hands of your presence and graciously you and you are credited with solving my problem
Thank you, Professor Generous with all my heart
and elso thanks alot for mr.Hui
 
Top