Author Topic: How to Excel Master Thread  (Read 2904 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: 2962
  • Total likes: 103
  • 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: 1070
  • 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: 11642
  • Total likes: 5774
  • DansDeals.com Hat Tips 8
    • 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
Feelings don't care about your facts

Offline ChaimMoskowitz

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jun 2014
  • Posts: 6669
  • Total likes: 1070
  • 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: 11642
  • Total likes: 5774
  • DansDeals.com Hat Tips 8
    • 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.
Feelings don't care about your facts

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 11778
  • Total likes: 1695
  • 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: 1070
  • 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!

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 11778
  • Total likes: 1695
  • 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: 1070
  • 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: 11642
  • Total likes: 5774
  • DansDeals.com Hat Tips 8
    • 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.
Feelings don't care about your facts

Offline ChaimMoskowitz

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jun 2014
  • Posts: 6669
  • Total likes: 1070
  • 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: 11642
  • Total likes: 5774
  • DansDeals.com Hat Tips 8
    • 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.
Feelings don't care about your facts

Offline ChaimMoskowitz

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jun 2014
  • Posts: 6669
  • Total likes: 1070
  • 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: 17
  • 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