Topic Wiki

For cool Excel spreadsheet template to keep track of all Credit Card stuff, see here
« Last edited by shoobi on November 12, 2015, 11:24:07 PM »

Author Topic: Excel Help and Problems  (Read 165128 times)

Offline Yammer

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Aug 2015
  • Posts: 3697
  • Total likes: 215
  • DansDeals.com Hat Tips 1
    • View Profile
Re: Excel Problem
« Reply #700 on: December 28, 2016, 12:14:40 AM »
i have a big list of names in one column. Is there a way to check if there is any exact name double?
Select the column,
 Go to the data tab,
Remove duplicates

Offline Yammer

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Aug 2015
  • Posts: 3697
  • Total likes: 215
  • DansDeals.com Hat Tips 1
    • View Profile
Re: Excel Problem
« Reply #701 on: December 28, 2016, 12:20:19 AM »
I edited a video and was trying to find a time format for it. Went to formula bar; time: 2nd option (13:30). ( And the 37:30:55)
Tried :04-:18  but it wouldn't work.

Any suggestions?

Offline shulem92

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Feb 2015
  • Posts: 2981
  • Total likes: 109
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #702 on: December 28, 2016, 01:04:35 AM »
Any ideas how come a fedex tracking number becomes an equation whenever I copy paste into excel?

Offline Zalc

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Nov 2014
  • Posts: 1555
  • Total likes: 61
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: USA
Re: Excel Problem
« Reply #703 on: December 28, 2016, 02:03:32 AM »
Any ideas how come a fedex tracking number becomes an equation whenever I copy paste into excel?
Dunno, but it can try setting the cell that you paste it into as "text" first, in place of the default "general"

It's a drop down menu on the first page of the ribbon

Offline AsherO

  • Global Moderator
  • Dansdeals Lifetime 20K Presidential Platinum Elite
  • **********
  • Join Date: May 2008
  • Posts: 26051
  • Total likes: 3215
  • DansDeals.com Hat Tips 75
    • View Profile
  • Location: NYC
Re: Excel Problem
« Reply #704 on: December 28, 2016, 07:50:25 AM »
I edited a video and was trying to find a time format for it. Went to formula bar; time: 2nd option (13:30). ( And the 37:30:55)
Tried :04-:18  but it wouldn't work.

Any suggestions?

I don't follow, your timestamp is >24 hours?

Offline JTZ

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Apr 2016
  • Posts: 1903
  • Total likes: 228
  • DansDeals.com Hat Tips 1
    • View Profile
Re: Excel Problem
« Reply #705 on: December 28, 2016, 07:53:17 AM »
Any ideas how come a fedex tracking number becomes an equation whenever I copy paste into excel?
I have the same problem with CC #'s.
"LESS IS MORE" It is the cumulative effect that kills deals!!! How many times do I have to say this?  >:(

Offline Zalc

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Nov 2014
  • Posts: 1555
  • Total likes: 61
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: USA
Re: Excel Problem
« Reply #706 on: December 28, 2016, 08:32:23 AM »
I have the same problem with CC #'s.
Even if you set the cell format to text before pasting?

Pasting anything with leading 0's is also affected by this

Offline CZ60

  • Dansdeals Platinum Elite
  • ****
  • Join Date: Jul 2014
  • Posts: 431
  • Total likes: 38
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: New York
Re: Excel Problem
« Reply #707 on: December 28, 2016, 08:50:52 AM »
You must set the cell format to text before pasting in. Otherwise, by default, excel will read it as a number. And by default, excel can only handle 15 digits (see: https://support.microsoft.com/en-us/kb/269370)

If you change it to text after the fact, the digits after the 15th will be 0's and you'll lose them for good. If you change it before the fact, it'll store them as text and keep them. Note that on text formatting, you cannot make equations from the contents of that cell (maybe adding to cc #'s together will get you the next Powerball #'s ??? )

Offline CZ60

  • Dansdeals Platinum Elite
  • ****
  • Join Date: Jul 2014
  • Posts: 431
  • Total likes: 38
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: New York
Re: Excel Problem
« Reply #708 on: December 28, 2016, 08:52:30 AM »
Any ideas how come a fedex tracking number becomes an equation whenever I copy paste into excel?
A formula? What do you mean by that? Scientific notation? Such as 1E+9, or something like that?

Offline CZ60

  • Dansdeals Platinum Elite
  • ****
  • Join Date: Jul 2014
  • Posts: 431
  • Total likes: 38
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: New York
Re: Excel Problem
« Reply #709 on: December 28, 2016, 08:52:58 AM »
I don't follow, your timestamp is >24 hours?

+1, dont' follow.

Offline aygart

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: May 2008
  • Posts: 13063
  • Total likes: 7715
  • DansDeals.com Hat Tips 11
    • View Profile
    • Lower Watt Energy Brokers
  • Programs: www.lowerwatt.com
Re: Excel Problem
« Reply #710 on: December 28, 2016, 09:28:15 AM »
You must set the cell format to text before pasting in. Otherwise, by default, excel will read it as a number. And by default, excel can only handle 15 digits (see: https://support.microsoft.com/en-us/kb/269370)

If you change it to text after the fact, the digits after the 15th will be 0's and you'll lose them for good. If you change it before the fact, it'll store them as text and keep them. Note that on text formatting, you cannot make equations from the contents of that cell (maybe adding to cc #'s together will get you the next Powerball #'s ??? )
Alternatively you can add a ' before the number
Feelings don't care about your facts

Offline Yammer

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Aug 2015
  • Posts: 3697
  • Total likes: 215
  • DansDeals.com Hat Tips 1
    • View Profile
Re: Excel Problem
« Reply #711 on: December 28, 2016, 09:31:24 AM »
I don't follow, your timestamp is >24 hours?
The video is 45 min. I need to start from :00-45:00
« Last Edit: December 28, 2016, 09:40:02 AM by Yammer »

Offline JTZ

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Apr 2016
  • Posts: 1903
  • Total likes: 228
  • DansDeals.com Hat Tips 1
    • View Profile
Re: Excel Problem
« Reply #712 on: December 28, 2016, 09:45:55 AM »
You must set the cell format to text before pasting in. Otherwise, by default, excel will read it as a number. And by default, excel can only handle 15 digits (see: https://support.microsoft.com/en-us/kb/269370)

If you change it to text after the fact, the digits after the 15th will be 0's and you'll lose them for good. If you change it before the fact, it'll store them as text and keep them. Note that on text formatting, you cannot make equations from the contents of that cell (maybe adding to cc #'s together will get you the next Powerball #'s ??? )
I was doing it after the fact.  :-[
"LESS IS MORE" It is the cumulative effect that kills deals!!! How many times do I have to say this?  >:(

Offline shulem92

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Feb 2015
  • Posts: 2981
  • Total likes: 109
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #713 on: December 28, 2016, 12:24:51 PM »
Dunno, but it can try setting the cell that you paste it into as "text" first, in place of the default "general"

It's a drop down menu on the first page of the ribbon
Thanx it worked
A formula? What do you mean by that? Scientific notation? Such as 1E+9, or something like that?
I put in a 12 digit number. I.e. 712837582475 and would get 7.12837E+11 in return

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12125
  • Total likes: 2173
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Problem
« Reply #714 on: December 28, 2016, 12:44:53 PM »
Thanx it workedI put in a 12 digit number. I.e. 712837582475 and would get 7.12837E+11 in return
This works great:
Alternatively you can add a ' before the number
Workflowy. You won't know what you're missing until you try it.

Offline CZ60

  • Dansdeals Platinum Elite
  • ****
  • Join Date: Jul 2014
  • Posts: 431
  • Total likes: 38
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: New York
Re: Excel Problem
« Reply #715 on: December 28, 2016, 12:49:40 PM »
Thanx it workedI put in a 12 digit number. I.e. 712837582475 and would get 7.12837E+11 in return

Widen the column. Should display fully. If not, check the formatting that it's in number format.

Offline shulem92

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Feb 2015
  • Posts: 2981
  • Total likes: 109
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #716 on: December 28, 2016, 12:55:26 PM »
Widen the column. Should display fully. If not, check the formatting that it's in number format.
It only works if in numbers, standard on this sheet is general, so once I'm changing it, I can just change it to text. Thanx

Offline shulem92

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Feb 2015
  • Posts: 2981
  • Total likes: 109
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #717 on: December 28, 2016, 12:56:19 PM »
This works great:
I did that, I wrote FedEx... But then when I wanted to copy and paste into FedEx tracking system, it obv wouldn't work...

Offline shulem92

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Feb 2015
  • Posts: 2981
  • Total likes: 109
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #718 on: December 28, 2016, 12:57:56 PM »
Random question, maybe this is the wrong thread. Does anyone know of a quick convenient way to get my last years worth of chase cc statements into excel?

Offline Yisroel Tech

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Dec 2015
  • Posts: 1819
  • Total likes: 236
  • DansDeals.com Hat Tips 2
  • Gender: Male
    • View Profile
  • Location: Monsey, NY
Re: Excel Problem
« Reply #719 on: December 28, 2016, 02:33:02 PM »
Random question, maybe this is the wrong thread. Does anyone know of a quick convenient way to get my last years worth of chase cc statements into excel?
Have it in downloaded (not scanned) PDF files? And PDF-to-Excel software should do it just ok. If you don't have Adobe Acrobat Pro you can try a free online service like this https://smallpdf.com/pdf-to-excel or this https://www.pdftoexcelonline.com/en/