My name is ***** ***** I will be assisting you today.
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)
can you hold for a min while i try please
its come up as anumber, can it be a %
Yes, you change the format of column B to a number format and make it a percentage.
Right-click on the column header so it selects the full column, then choose "Format"
format doesnt give me % can you talk ?
We can only offer online chat. But give me just a minute.
When you click "Format Cells", click the "Number" tab. "Percentage" is the 7th option down
Is this just going to be used for display, or will you be using the percentage to do additional calculations?
yes for additional calculations.......it says % in the tab at the top in the middle but its number 50 not 50%
Ok. Then we're going about this wrong. I thought you just wanted it for display. Give me a minute.
Ok, you want: =Value(Right(A1, 2)) / 100
Does that work for you?
You're welcome. Have a great day!
Please don't forget to rate my service before you go.