Welcome Guest
You last visited December 4, 2016, 3:15 pm
All times shown are
Eastern Time (GMT-5:00)

# Any EXCEL pro's out there?

Topic closed. 7 replies. Last post 11 years ago by lottaloot.

 Page 1 of 1
SC
United States
Member #24908
October 28, 2005
62 Posts
Offline
 Posted: November 13, 2005, 4:05 pm - IP Logged

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, 13 to a 3, 14 to a 4, etc....

Thank you again to anyone willing to help! I guess I need to get EXCEL for Dummies!

Best of luck to you all!

Angie

Charlotte NC
United States
Member #17406
June 18, 2005
4053 Posts
Offline
 Posted: November 13, 2005, 4:23 pm - IP Logged

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

takeemtothebank

SC
United States
Member #24908
October 28, 2005
62 Posts
Offline
 Posted: November 13, 2005, 4:25 pm - IP Logged

Thank you so much!!!

Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
 Posted: November 13, 2005, 5:23 pm - IP Logged

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, 13 to a 3, 14 to a 4, etc....

Thank you again to anyone willing to help! I guess I need to get EXCEL for Dummies!

Best of luck to you all!

Angie

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.

L ttaL   T

SC
United States
Member #24908
October 28, 2005
62 Posts
Offline
 Posted: November 13, 2005, 5:30 pm - IP Logged

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 advice I can get!  Thanks again!

Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
 Posted: November 13, 2005, 5:43 pm - IP Logged

=RIGHT(A3,1)*1

Try this & see what happens

This formula returns only the right side of the result

10 would result in 0

11 would result in 1

If you wanted the Left side

=LEFT(A3,1)*1

L ttaL   T

SC
United States
Member #24908
October 28, 2005
62 Posts
Offline
 Posted: November 13, 2005, 5:47 pm - IP Logged

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!
Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
 Posted: November 15, 2005, 4:40 pm - IP Logged

You're welcome.

SirMetro would be so proud of me.

He taught me almost everything I know about excel.

L ttaL   T

 Page 1 of 1