How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Bryan Your Own Question

Bryan
Bryan, Computer Repairer
Category: Computer
Satisfied Customers: 1445
Experience:  Hardware/Software/Viruses/Malware/Spyware .. I can help you fix it all.
59162784
Type Your Computer Question Here...
Bryan is online now

hi could you give me the formula to read the last 2 numbers

Resolved Question:

hi could you give me the formula to read the last 2 numbers in a cell that has P0307F23-44 in it , that will bring over 44% to another cell, thank you
Submitted: 2 years ago.
Category: Computer
Expert:  replied 2 years ago.
Bryan :

My name is ***** ***** I will be assisting you today.

Bryan :

Ok, let's say that the original value is in A1 and you want to place the last 2 characters into B1:

B1 would be: =RIGHT(A1, 2)

Customer:

can you hold for a min while i try please

Bryan :

No problem

Customer:

its come up as anumber, can it be a %

Bryan :

Yes, you change the format of column B to a number format and make it a percentage.

Bryan :

Right-click on the column header so it selects the full column, then choose "Format"

Customer:

format doesnt give me % can you talk ?

Bryan :

We can only offer online chat. But give me just a minute.

Bryan :

When you click "Format Cells", click the "Number" tab. "Percentage" is the 7th option down

Bryan :

Is this just going to be used for display, or will you be using the percentage to do additional calculations?

Customer:

yes for additional calculations.......it says % in the tab at the top in the middle but its number 50 not 50%

Bryan :

Ok. Then we're going about this wrong. I thought you just wanted it for display. Give me a minute.

Bryan :

Ok, you want: =Value(Right(A1, 2)) / 100

Bryan :

Does that work for you?

Customer:

yes thanks

Bryan :

You're welcome. Have a great day!

Bryan :

Please don't forget to rate my service before you go.

Bryan, Computer Repairer
Category: Computer
Satisfied Customers: 1445
Experience: Hardware/Software/Viruses/Malware/Spyware .. I can help you fix it all.
Bryan and other Computer Specialists are ready to help you

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
< Previous | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
 
 
 

Meet The Experts:

 
 
 
  • Kamil Anwar

    Kamil Anwar

    Computer Support Specialist

    Satisfied Customers:

    161
    8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.
< Previous | Next >
  • http://ww2.justanswer.co.uk/uploads/JA/JACUSTOMERf8udkdxk/2013-8-3_15150_323738101505074393259301621172992o.64x64.jpg Kamil Anwar's Avatar

    Kamil Anwar

    Computer Support Specialist

    Satisfied Customers:

    161
    8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.
  • http://ww2.justanswer.co.uk/uploads/WI/Windowspcfix/2013-8-19_153826_ja12.64x64.jpg James K.'s Avatar

    James K.

    Consultant

    Satisfied Customers:

    93
    Technical Director of IT Company
  • http://ww2.justanswer.co.uk/uploads/JO/JonTech/2011-10-25_111835_A2c.64x64.jpg Jon-Tech's Avatar

    Jon-Tech

    IS Manager

    Satisfied Customers:

    61
    20 yrs: Computers, Networking
  • http://ww2.justanswer.co.uk/uploads/JA/jamieratliff/2012-2-8_194551_jamie.64x64.jpg jamieratliff's Avatar

    jamieratliff

    Information Systems Manager

    Satisfied Customers:

    21
    Jamie has worked in the Information Technology field for over a decade.
  • http://ww2.justanswer.co.uk/uploads/JA/JACUSTOMERleg4q7o8/2012-3-6_203036_meja.64x64.png TheDoctor's Avatar

    TheDoctor

    Software Engineer

    Satisfied Customers:

    16
    Experienced Software Engineer
  • http://ww2.justanswer.co.uk/uploads/FI/FisherEngineering/2012-1-18_194422_Fisher375Headshotcompressed239K.64x64.jpg Bill Fisher's Avatar

    Bill Fisher

    Computer Engineer

    Satisfied Customers:

    1
    Computer system design, networks, integration, general support.
  • http://ww2.justanswer.co.uk/uploads/ZE/zeyank/2014-12-9_221254_zeyank.64x64.png Ryan H.'s Avatar

    Ryan H.

    Computer Support Specialist

    Satisfied Customers:

    1739
    A+ Certified Technician - 10 Years experience working with all types of computer systems.