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

Offline lubaby

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jun 2010
  • Posts: 5335
  • Total likes: 736
  • DansDeals.com Hat Tips 12
    • View Profile
Re: Excel help
« Reply #80 on: April 07, 2014, 09:24:33 PM »
Won't that print as '08701? That doesn't look right...
No. The ' tells Excel to format the field as text and save exactly what you type in. Nothing is noticeable when you print.
You can always do Print Preview to see how it will look once printed.

Offline chucksterace

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 6880
  • Total likes: 19
  • DansDeals.com Hat Tips 40
  • Gender: Male
    • View Profile
    • LYNX IT Consulting
  • Location: Chicago, Jerusalem
  • Programs: AA Exec Plat; UA Premier 1K; ; LY Plat; Hyatt Platinum; Hertz President's Circle; Avis President's Club
Re: Excel help
« Reply #81 on: April 07, 2014, 09:25:10 PM »
No. The ' tells Excel to format the field as text and save exactly what you type in. Nothing is noticeable when you print.
You can always do Print Preview to see how it will look once printed.

Or just to print to PDF and see also
You may not hold me responsible for any actions taken that were recommended from my account or username.

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
« Reply #82 on: April 07, 2014, 09:26:44 PM »

Offline katherine123

  • Dansdeals Platinum Elite
  • ****
  • Join Date: Oct 2013
  • Posts: 344
  • Total likes: 0
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: USA
Re: Excel help
« Reply #83 on: April 07, 2014, 09:34:14 PM »

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
« Reply #84 on: April 07, 2014, 09:38:17 PM »
I tried that, it didn't work.
It should..
ETA it does
« Last Edit: April 07, 2014, 09:45:40 PM by churnbabychurn »

Offline yitzf

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 2623
  • Total likes: 52
  • DansDeals.com Hat Tips 4
    • View Profile
Re: Excel help
« Reply #85 on: April 07, 2014, 10:12:33 PM »
It should..
ETA it does

I vaguely remember it not working when I mail merged it in word, it would lose the 0. What I did was =IF(LEN(A1)=4,"08701",A1) where A1 is the zip code, and just copied it all the way down the list. Obviously only works if the only zip starting with a 0 in your list is Lakewood.

Offline bubbles

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2011
  • Posts: 5060
  • Total likes: 20
  • DansDeals.com Hat Tips 67
    • View Profile
Re: Excel help
« Reply #86 on: April 07, 2014, 10:14:24 PM »
I vaguely remember it not working when I mail merged it in word, it would lose the 0. What I did was =IF(LEN(A1)=4,"08701",A1) where A1 is the zip code, and just copied it all the way down the list. Obviously only works if the only zip starting with a 0 in your list is Lakewood.

I don't think it's necessary to do it this way, but if you want...
=IF(LEN(A1)=4,CONCATENATE("0",A1),A1)

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
« Reply #87 on: April 07, 2014, 10:16:12 PM »
how does adding a leading zero through a formula prevent it from getting lost due to a number format issue?

Online etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12861
  • Total likes: 3316
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel help
« Reply #88 on: April 07, 2014, 10:17:49 PM »
I vaguely remember it not working when I mail merged it in word, it would lose the 0. What I did was =IF(LEN(A1)=4,"08701",A1) where A1 is the zip code, and just copied it all the way down the list. Obviously only works if the only zip starting with a 0 in your list is Lakewood.
to work for other zip codes you could change it to
=IF(LEN(A1)=4,"0"&A1,A1)
Workflowy. You won't know what you're missing until you try it.

Online etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12861
  • Total likes: 3316
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel help
« Reply #89 on: April 07, 2014, 10:18:08 PM »
how does adding a leading zero through a formula prevent it from getting lost due to a number format issue?
but you're right
Workflowy. You won't know what you're missing until you try it.

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
« Reply #90 on: April 07, 2014, 10:22:25 PM »
The problem is with a word mail merge, nothing wrong with excel's zip code format. In word there should be an option to format the field as zip also

Offline yitzf

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 2623
  • Total likes: 52
  • DansDeals.com Hat Tips 4
    • View Profile
Re: Excel help
« Reply #91 on: April 07, 2014, 10:26:54 PM »
I don't think it's necessary to do it this way, but if you want...
=IF(LEN(A1)=4,CONCATENATE("0",A1),A1)

Now that you mention it, I think that's what I did. (I know I wasn't so tied down to lakewood  :) )

Offline jack12

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Dec 2008
  • Posts: 1139
  • Total likes: 5
  • DansDeals.com Hat Tips 8
    • View Profile
  • Programs: National Emerald Club Executive Elite, Hertz #1 Club Gold Presidents Circle, Sixt Platinum
Re: Excel help
« Reply #92 on: April 08, 2014, 07:23:45 AM »
Funny how this issue only comes up with lakewood :)
All New Jersey zip codes start with a 0

Offline chucksterace

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 6880
  • Total likes: 19
  • DansDeals.com Hat Tips 40
  • Gender: Male
    • View Profile
    • LYNX IT Consulting
  • Location: Chicago, Jerusalem
  • Programs: AA Exec Plat; UA Premier 1K; ; LY Plat; Hyatt Platinum; Hertz President's Circle; Avis President's Club
Re: Excel help
« Reply #93 on: April 08, 2014, 07:44:41 AM »

All New Jersey zip codes start with a 0

And why would no one mention that earlier. ???
You may not hold me responsible for any actions taken that were recommended from my account or username.

Online etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12861
  • Total likes: 3316
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel help
« Reply #94 on: April 08, 2014, 08:57:01 AM »
And why would no one mention that earlier. ???
That's the funny part...
Workflowy. You won't know what you're missing until you try it.

Offline AnonymousUser

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Feb 2013
  • Posts: 3001
  • Total likes: 13
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel help
« Reply #95 on: April 08, 2014, 09:46:02 AM »
And why would no one mention that earlier. ???
You mean there are places in NJ besides Lakewood??? ;)

Offline chucksterace

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 6880
  • Total likes: 19
  • DansDeals.com Hat Tips 40
  • Gender: Male
    • View Profile
    • LYNX IT Consulting
  • Location: Chicago, Jerusalem
  • Programs: AA Exec Plat; UA Premier 1K; ; LY Plat; Hyatt Platinum; Hertz President's Circle; Avis President's Club
Re: Excel help
« Reply #96 on: April 08, 2014, 09:47:03 AM »

You mean there are places in NJ besides Lakewood??? ;)

Nope. :P
You may not hold me responsible for any actions taken that were recommended from my account or username.

Online etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12861
  • Total likes: 3316
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel help
« Reply #97 on: April 08, 2014, 10:11:41 AM »
Nope. :P
Sorry guys, but I'm moving to Passaic in less than a month...
Workflowy. You won't know what you're missing until you try it.

Offline jack12

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Dec 2008
  • Posts: 1139
  • Total likes: 5
  • DansDeals.com Hat Tips 8
    • View Profile
  • Programs: National Emerald Club Executive Elite, Hertz #1 Club Gold Presidents Circle, Sixt Platinum
Re: Excel help
« Reply #98 on: April 08, 2014, 12:16:37 PM »
All New Jersey zip codes start with a 0
Other states do too. From Wikipedia: 0 = Connecticut (CT), Massachusetts (MA), Maine (ME), New Hampshire (NH), New Jersey (NJ), Puerto Rico (PR), Rhode Island (RI), Vermont (VT), Virgin Islands (VI), Army Post Office Europe (AE), Fleet Post Office Europe (AE)

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 Problem
« Reply #99 on: May 19, 2014, 09:35:42 AM »
Whats an easy way to remove every second row of data?