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 94578 times)

Offline unavailable

  • Dansdeals Platinum Elite
  • ****
  • Join Date: Dec 2013
  • Posts: 475
  • Total likes: 7
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: bp
Re: Excel Help and Problems
« Reply #1260 on: May 23, 2019, 06:09:15 PM »
YES!

thank you all!

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7185
  • Total likes: 272
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Help and Problems
« Reply #1261 on: June 18, 2019, 03:09:18 PM »
Anyone have a formula for yield maintenance?

Online CountValentine

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2013
  • Posts: 4858
  • Total likes: 252
  • DansDeals.com Hat Tips 0
  • Gender: Male
    • View Profile
  • Location: Poland
  • Programs: DAOTYA
Re: Excel Help and Problems
« Reply #1262 on: June 22, 2019, 11:24:49 PM »
How do I stop a cell from changing this 1234567890123456 to this 1.23457E+15
You're so far up Trump's a** you can see Giuliani's feet.  HT Baruch

Offline farmbochur

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Dec 2011
  • Posts: 1419
  • Total likes: 79
  • DansDeals.com Hat Tips 6
    • View Profile
Re: Excel Help and Problems
« Reply #1263 on: June 23, 2019, 12:21:45 AM »
Place a single quote at the beginning of the string
Risk is opportunity

Online etech0

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2013
  • Posts: 9453
  • Total likes: 333
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Help and Problems
« Reply #1264 on: June 23, 2019, 12:25:53 AM »
How do I stop a cell from changing this 1234567890123456 to this 1.23457E+15
select the column, right click, Format cells, Custom and choose the option that says 0 (second option below General).

 
Workflowy. You won't know what you're missing until you try it.

Online CountValentine

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2013
  • Posts: 4858
  • Total likes: 252
  • DansDeals.com Hat Tips 0
  • Gender: Male
    • View Profile
  • Location: Poland
  • Programs: DAOTYA
Re: Excel Help and Problems
« Reply #1265 on: June 23, 2019, 05:35:11 AM »
Place a single quote at the beginning of the string
Any way to have the quote not show?
You're so far up Trump's a** you can see Giuliani's feet.  HT Baruch

Online CountValentine

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2013
  • Posts: 4858
  • Total likes: 252
  • DansDeals.com Hat Tips 0
  • Gender: Male
    • View Profile
  • Location: Poland
  • Programs: DAOTYA
Re: Excel Help and Problems
« Reply #1266 on: June 23, 2019, 05:36:25 AM »
select the column, right click, Format cells, Custom and choose the option that says 0 (second option below General).
It changes the last digit to a "0"
1234567890123456 changes to
1234567890123450
You're so far up Trump's a** you can see Giuliani's feet.  HT Baruch

Online skyguy918

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 2810
  • Total likes: 154
  • DansDeals.com Hat Tips 1
  • Gender: Male
    • View Profile
  • Location: Queens, NY
Re: Excel Help and Problems
« Reply #1267 on: June 23, 2019, 10:20:48 AM »
It changes the last digit to a "0"
1234567890123456 changes to
1234567890123450
If you need it stored as a number, Excel only stores 15 digits. If you don't care if it's stored as text, format it as text. The solution suggested earlier with a question mark is actually supposed to be an apostrophe. That will convert it to text without showing the apostrophe.

Online CountValentine

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2013
  • Posts: 4858
  • Total likes: 252
  • DansDeals.com Hat Tips 0
  • Gender: Male
    • View Profile
  • Location: Poland
  • Programs: DAOTYA
Re: Excel Help and Problems
« Reply #1268 on: June 23, 2019, 11:02:23 AM »
If you don't care if it's stored as text, format it as text.
That works but then every time I have an entry the cell has a stupid error indicator displayed that I have to clear.
You're so far up Trump's a** you can see Giuliani's feet.  HT Baruch

Online skyguy918

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 2810
  • Total likes: 154
  • DansDeals.com Hat Tips 1
  • Gender: Male
    • View Profile
  • Location: Queens, NY
Re: Excel Help and Problems
« Reply #1269 on: June 23, 2019, 11:34:32 AM »
That works but then every time I have an entry the cell has a stupid error indicator displayed that I have to clear.
You don't have to clear it, just leave it alone.

Online etech0

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2013
  • Posts: 9453
  • Total likes: 333
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Help and Problems
« Reply #1270 on: June 23, 2019, 12:05:47 PM »
It changes the last digit to a "0"
1234567890123456 changes to
1234567890123450
even if you type in the number after doing the above steps?
Workflowy. You won't know what you're missing until you try it.

Online CountValentine

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2013
  • Posts: 4858
  • Total likes: 252
  • DansDeals.com Hat Tips 0
  • Gender: Male
    • View Profile
  • Location: Poland
  • Programs: DAOTYA
Re: Excel Help and Problems
« Reply #1271 on: June 23, 2019, 12:08:05 PM »
You don't have to clear it, just leave it alone.
...but it bugs me. There has to be a way to enter 10-20 digits without issue, no?
You're so far up Trump's a** you can see Giuliani's feet.  HT Baruch

Online CountValentine

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2013
  • Posts: 4858
  • Total likes: 252
  • DansDeals.com Hat Tips 0
  • Gender: Male
    • View Profile
  • Location: Poland
  • Programs: DAOTYA
Re: Excel Help and Problems
« Reply #1272 on: June 23, 2019, 12:09:03 PM »
even if you type in the number after doing the above steps?
Yes unless I am doing something wrong which is a strong possibility.  :)
You're so far up Trump's a** you can see Giuliani's feet.  HT Baruch

Online etech0

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2013
  • Posts: 9453
  • Total likes: 333
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Help and Problems
« Reply #1273 on: June 23, 2019, 12:14:49 PM »
Yes unless I am doing something wrong which is a strong possibility.  :)
hmm... try formatting as Text then
Workflowy. You won't know what you're missing until you try it.

Online CountValentine

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2013
  • Posts: 4858
  • Total likes: 252
  • DansDeals.com Hat Tips 0
  • Gender: Male
    • View Profile
  • Location: Poland
  • Programs: DAOTYA
Re: Excel Help and Problems
« Reply #1274 on: June 23, 2019, 12:22:09 PM »
hmm... try formatting as Text then
Then it gives a little triangle in the top left of the cell indicating an error.
I thought Excel was powerful. It can't store a 20 digit number properly? That is sad.
You're so far up Trump's a** you can see Giuliani's feet.  HT Baruch