Author Topic: How to Excel Master Thread  (Read 2694 times)

Offline Excalibur

  • Dansdeals Platinum Elite + Lifetime Silver Elite
  • *****
  • Join Date: May 2013
  • Posts: 506
  • Total likes: 1
  • DansDeals.com Hat Tips 1
    • View Profile
How to Excel Master Thread
« on: January 29, 2017, 03:27:34 PM »
Hey everybody. Thank G-d as I'm progressing professionally I'm running into more challenging tasks. I'm picking up a lot in Excel but still need help. I figure everyone could benefit from this thread that uses excel or is in accounting.

So, does anyone know how to extrapolate from a line on one excel workbook to another across multiple sheets?

TIA

Offline shulem92

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Feb 2015
  • Posts: 2956
  • Total likes: 100
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: Lakewood
Re: How to Excel Master Thread
« Reply #1 on: January 29, 2017, 03:40:53 PM »
Hey everybody. Thank G-d as I'm progressing professionally I'm running into more challenging tasks. I'm picking up a lot in Excel but still need help. I figure everyone could benefit from this thread that uses excel or is in accounting.

So, does anyone know how to extrapolate from a line on one excel workbook to another across multiple sheets?

TIA
Are you aware that there already is an excel thread?
http://forums.dansdeals.com/index.php?topic=35830.0

Offline ChaimMoskowitz

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jun 2014
  • Posts: 6669
  • Total likes: 1058
  • DansDeals.com Hat Tips 1
  • Gender: Female
    • View Profile
Re: How to Excel Master Thread
« Reply #2 on: May 14, 2017, 07:03:15 PM »
Need to save CC #'s. I was told to set the cell as text to save properly. It works but shows and error as "The number in this cell is formatted as text". How do I get rid of that error?
I just found a new supply of forks!

Offline aygart

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: May 2008
  • Posts: 10034
  • Total likes: 3778
  • DansDeals.com Hat Tips 7
    • View Profile
    • Lower Watt Energy Brokers
  • Programs: www.lowerwatt.com
Re: How to Excel Master Thread
« Reply #3 on: May 14, 2017, 07:24:23 PM »
Need to save CC #'s. I was told to set the cell as text to save properly. It works but shows and error as "The number in this cell is formatted as text". How do I get rid of that error?
What is the issue with it showing that error
The thing with the hamster is that running on the wheel is actually what it is trying to do.

Offline ChaimMoskowitz

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jun 2014
  • Posts: 6669
  • Total likes: 1058
  • DansDeals.com Hat Tips 1
  • Gender: Female
    • View Profile
Re: How to Excel Master Thread
« Reply #4 on: May 14, 2017, 07:25:45 PM »
What is the issue with it showing that error
Nothing but it bugs me. Seems there should be a way to store a 16 digit number without any errors.
I just found a new supply of forks!

Offline aygart

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: May 2008
  • Posts: 10034
  • Total likes: 3778
  • DansDeals.com Hat Tips 7
    • View Profile
    • Lower Watt Energy Brokers
  • Programs: www.lowerwatt.com
Re: How to Excel Master Thread
« Reply #5 on: May 14, 2017, 07:28:55 PM »
Nothing but it bugs me. Seems there should be a way to store a 16 digit number without any errors.
It is an annoyance but the best way. Sometimes putting am apostrophe before the number will work.
The thing with the hamster is that running on the wheel is actually what it is trying to do.

Online etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 11019
  • Total likes: 1092
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: How to Excel Master Thread
« Reply #6 on: May 14, 2017, 07:29:42 PM »
Workflowy. You won't know what you're missing until you try it.

Offline ChaimMoskowitz

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jun 2014
  • Posts: 6669
  • Total likes: 1058
  • DansDeals.com Hat Tips 1
  • Gender: Female
    • View Profile
Re: How to Excel Master Thread
« Reply #7 on: May 14, 2017, 07:34:31 PM »
ETA: try this https://support.office.com/en-us/article/Fix-text-formatted-numbers-by-applying-a-number-format-6599c03a-954d-4d83-b78a-23af2c8845d0#__toc260840021
That did it, thanks.

Now the next issue.  :)
Entering a number with leading zero(s) it deletes them. How do I get them to show?
I just found a new supply of forks!

Online etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 11019
  • Total likes: 1092
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: How to Excel Master Thread
« Reply #8 on: May 14, 2017, 07:35:35 PM »
That did it, thanks.

Now the next issue.  :)
Entering a number with leading zero(s) it deletes them. How do I get them to show?
YW. Put an apostrophe before the 0.
Workflowy. You won't know what you're missing until you try it.

Offline ChaimMoskowitz

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jun 2014
  • Posts: 6669
  • Total likes: 1058
  • DansDeals.com Hat Tips 1
  • Gender: Female
    • View Profile
Re: How to Excel Master Thread
« Reply #9 on: May 14, 2017, 07:39:35 PM »
Put an apostrophe before the 0.
Not trying to be a pain but that is an extra keystroke and it adds up when doing thousands. No way to format the cell for a four digit number which might have leading zeros?
I just found a new supply of forks!

Offline aygart

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: May 2008
  • Posts: 10034
  • Total likes: 3778
  • DansDeals.com Hat Tips 7
    • View Profile
    • Lower Watt Energy Brokers
  • Programs: www.lowerwatt.com
Re: How to Excel Master Thread
« Reply #10 on: May 14, 2017, 07:41:13 PM »
Not trying to be a pain but that is an extra keystroke and it adds up when doing thousands. No way to format the cell for a four digit number which might have leading zeros?
Text

ETA, try formatting it as the last 4 of a zip code. I think that is an option.
The thing with the hamster is that running on the wheel is actually what it is trying to do.

Offline ChaimMoskowitz

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jun 2014
  • Posts: 6669
  • Total likes: 1058
  • DansDeals.com Hat Tips 1
  • Gender: Female
    • View Profile
Re: How to Excel Master Thread
« Reply #11 on: May 14, 2017, 07:43:52 PM »
Text
Talk about being brain dead.   :-[
I just found a new supply of forks!

Offline aygart

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: May 2008
  • Posts: 10034
  • Total likes: 3778
  • DansDeals.com Hat Tips 7
    • View Profile
    • Lower Watt Energy Brokers
  • Programs: www.lowerwatt.com
Re: How to Excel Master Thread
« Reply #12 on: May 14, 2017, 07:45:01 PM »
Talk about being brain dead.   :-[
See my edit.

I deal with this issue all the time and have not found a better way.
The thing with the hamster is that running on the wheel is actually what it is trying to do.

Offline ChaimMoskowitz

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jun 2014
  • Posts: 6669
  • Total likes: 1058
  • DansDeals.com Hat Tips 1
  • Gender: Female
    • View Profile
Re: How to Excel Master Thread
« Reply #13 on: May 14, 2017, 07:47:18 PM »
See my edit.

I deal with this issue all the time and have not found a better way.
Text works just fine. My brain is not working today.
I just found a new supply of forks!

Offline bubbles

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2011
  • Posts: 5055
  • Total likes: 16
  • DansDeals.com Hat Tips 67
    • View Profile
Re: How to Excel Master Thread
« Reply #14 on: May 14, 2017, 11:21:57 PM »
If you don't realize till after the fact. =TEXT(A2,"0000") will add in a leading zero to any 3 digit number while maintaining 4 digit numbers as is