Any EXCEL pro's out there?

Reply #7

lottaloot — Tue, 15 Nov 2005 21:40:26 GMT

You're welcome. SirMetro would be so proud of me.He taught me almost everything I know about excel.

Reply #6

ayr92766 — Sun, 13 Nov 2005 22:47:24 GMT

I think that did the trick! Thank you so much...I used to could zip right through Excel, it's been years since I've tinkered with it. Always fun learning over again though!!! You are a jewel! Thanks again for your help

Reply #5

lottaloot — Sun, 13 Nov 2005 22:43:45 GMT

=RIGHT(A3,1)*1Try this see what happensThis formula returns only the right side of the result10 would result in 011 would result in 1If you wanted the Left side=LEFT(A3,1)*1

Reply #4

ayr92766 — Sun, 13 Nov 2005 22:30:18 GMT

Hi.... ok let me try to explain...After adding (say for instance) A3=A2+5 If the answer to this equation is 10, 11, 12, 13, 14, 15, 16, 17, 18, 19 - how can I make it only input a 0, 1, 2, 3, 4, 5, 6, 7, 8, 9 (10 = 0, 11 = 1, 12 = 2, etc.)Sorry if it sounds stupid, it makes sense in my head, just not so sure how to explain it. I appreciate your help lottaloot - I've followed your posts and am very impressed!I'm new at all this and just starting to dabble in it, but I gladly accept all the a... [ More ]

Reply #3

lottaloot — Sun, 13 Nov 2005 22:23:51 GMT

Exactly what are you trying to do? Are you just looking to change the numbers??Are you trying to find the last digit of the sum???I do not understand what you are looking to do. Please rephrase the question.

Reply #2

ayr92766 — Sun, 13 Nov 2005 21:25:40 GMT

Thank you so much

Reply #1

Tenaj — Sun, 13 Nov 2005 21:23:25 GMT

Format / Cell and change the decimal places. I always go into help when I forget, no need to purchase a book.

Any EXCEL pro's out there?

ayr92766 — Sun, 13 Nov 2005 21:05:46 GMT

Hi, It's been a VERY long time since I've used excel. I know the basics, but have forgotten a few things. Was wondering if anyone could help me out with a formula. I am making system if you will that I've been trying on paper... but can't quite figure out how to make excel do what I want it to, lol. It's probably very easy, and staring me in the face... any help would be greatly appreciated!!! I hope this doesn't sound too stupid.How do I make it change a 10 to a 0, an 11 to a 11, 12 to a 2, 1... [ More ]