Topic Wiki

Rule 1: Did you try A.I? Right before you click post, give it a quick run. Most excel questions can be answered very quickly, thoroughly, and clearly via chatgpt. Wrong answer, or having trouble with the correct wording of the prompt? Post for help

=================
For cool Excel spreadsheet template to keep track of all Credit Card stuff, see here
« Last edited by Jojo202 on March 01, 2024, 12:09:44 AM »

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

Offline unavailable

  • Dansdeals Platinum Elite + Lifetime Silver Elite
  • *****
  • Join Date: Dec 2013
  • Posts: 545
  • Total likes: 20
  • 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: 7355
  • Total likes: 301
  • 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?

Offline CountValentine

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Mar 2013
  • Posts: 15775
  • Total likes: 7305
  • DansDeals.com Hat Tips -1
  • Gender: Female
    • View Profile
  • Location: Poland - Exiled
  • Programs: DAOTYA, DDF Level 3, 5K Lounge
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
Only on DDF does 24/6 mean 24/5/half/half

Offline farmbochur

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Dec 2011
  • Posts: 1795
  • Total likes: 232
  • DansDeals.com Hat Tips 19
    • 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

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12855
  • Total likes: 3302
  • 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.

Offline CountValentine

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Mar 2013
  • Posts: 15775
  • Total likes: 7305
  • DansDeals.com Hat Tips -1
  • Gender: Female
    • View Profile
  • Location: Poland - Exiled
  • Programs: DAOTYA, DDF Level 3, 5K Lounge
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?
Only on DDF does 24/6 mean 24/5/half/half

Offline CountValentine

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Mar 2013
  • Posts: 15775
  • Total likes: 7305
  • DansDeals.com Hat Tips -1
  • Gender: Female
    • View Profile
  • Location: Poland - Exiled
  • Programs: DAOTYA, DDF Level 3, 5K Lounge
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
Only on DDF does 24/6 mean 24/5/half/half

Offline skyguy918

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 3809
  • Total likes: 822
  • 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.

Offline CountValentine

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Mar 2013
  • Posts: 15775
  • Total likes: 7305
  • DansDeals.com Hat Tips -1
  • Gender: Female
    • View Profile
  • Location: Poland - Exiled
  • Programs: DAOTYA, DDF Level 3, 5K Lounge
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.
Only on DDF does 24/6 mean 24/5/half/half

Offline skyguy918

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 3809
  • Total likes: 822
  • 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.

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12855
  • Total likes: 3302
  • 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.

Offline CountValentine

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Mar 2013
  • Posts: 15775
  • Total likes: 7305
  • DansDeals.com Hat Tips -1
  • Gender: Female
    • View Profile
  • Location: Poland - Exiled
  • Programs: DAOTYA, DDF Level 3, 5K Lounge
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?
Only on DDF does 24/6 mean 24/5/half/half

Offline CountValentine

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Mar 2013
  • Posts: 15775
  • Total likes: 7305
  • DansDeals.com Hat Tips -1
  • Gender: Female
    • View Profile
  • Location: Poland - Exiled
  • Programs: DAOTYA, DDF Level 3, 5K Lounge
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.  :)
Only on DDF does 24/6 mean 24/5/half/half

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12855
  • Total likes: 3302
  • 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.

Offline CountValentine

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Mar 2013
  • Posts: 15775
  • Total likes: 7305
  • DansDeals.com Hat Tips -1
  • Gender: Female
    • View Profile
  • Location: Poland - Exiled
  • Programs: DAOTYA, DDF Level 3, 5K Lounge
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.
Only on DDF does 24/6 mean 24/5/half/half

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7355
  • Total likes: 301
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Help and Problems
« Reply #1275 on: June 23, 2019, 12:55:41 PM »
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.
Excel is for numbers, if you need to store text use word.

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12855
  • Total likes: 3302
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Help and Problems
« Reply #1276 on: June 23, 2019, 02:25:27 PM »
Excel is for numbers, if you need to store text use word.
Or possibly even MS Access
Workflowy. You won't know what you're missing until you try it.

Offline CountValentine

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Mar 2013
  • Posts: 15775
  • Total likes: 7305
  • DansDeals.com Hat Tips -1
  • Gender: Female
    • View Profile
  • Location: Poland - Exiled
  • Programs: DAOTYA, DDF Level 3, 5K Lounge
Re: Excel Help and Problems
« Reply #1277 on: June 23, 2019, 02:39:05 PM »
Access works great. Handles everything I throw at it. Unfortunately this script needs excel.
Only on DDF does 24/6 mean 24/5/half/half

Offline skyguy918

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 3809
  • Total likes: 822
  • DansDeals.com Hat Tips 1
  • Gender: Male
    • View Profile
  • Location: Queens, NY
Re: Excel Help and Problems
« Reply #1278 on: June 23, 2019, 03:29:07 PM »
Access works great. Handles everything I throw at it. Unfortunately this script needs excel.
There are supposedly addons that get around the 15 digit limit, here's an example:

http://precisioncalc.com/xlprecision.html

Can't personally vouch for it though.

Offline US

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Aug 2017
  • Posts: 1094
  • Total likes: 46
  • DansDeals.com Hat Tips 3
    • View Profile
Re: Excel Help and Problems
« Reply #1279 on: June 25, 2019, 01:43:25 PM »
Can someone please help me with SUMIF,

If cell A1 has any text, subtract cell A2 from A3,

I tried =SUMIF(K24:K24,"<>",Q24-V24) but keep on getting an error.