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 Problem  (Read 32281 times)

Offline chucksterace

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 6801
  • Total likes: 3
  • DansDeals.com Hat Tips 40
  • Gender: Male
    • View Profile
    • Flight Lynx
  • 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 #75 on: April 07, 2014, 09:22:05 PM »
Won't that print as '08701? That doesn't look right...

Don't think so. Just did a test run, print to PDF and came out good

ETA: Or you can go add a custom number, (where you would choose date, number, currency, etc) and just put in "00000" that way the minimum in the box would be five numbers and the zero would show.
You may not hold me responsible or liable for any actions taken that was recommended from my account or username.

Offline myb821

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Mar 2011
  • Posts: 7395
  • Total likes: 2
  • DansDeals.com Hat Tips 2
    • View Profile
  • Location: New York
Re: Excel help
« Reply #76 on: April 07, 2014, 09:23:09 PM »
or set it as text

Offline etech0

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2013
  • Posts: 7886
  • Total likes: 53
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel help
« Reply #77 on: April 07, 2014, 09:23:26 PM »
Won't that print as '08701? That doesn't look right...
Nope - I do it all the time. Funny how this issue only comes up with lakewood :)
Workflowy. You won't know what you're missing until you try it.

Offline chucksterace

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 6801
  • Total likes: 3
  • DansDeals.com Hat Tips 40
  • Gender: Male
    • View Profile
    • Flight Lynx
  • 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 #78 on: April 07, 2014, 09:24:08 PM »
Nope - I do it all the time. Funny how this issue only comes up with lakewood :)

Oh well. Good thing I don't live in lakewood  :P
You may not hold me responsible or liable for any actions taken that was recommended from my account or username.

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 #79 on: April 07, 2014, 09:24:25 PM »
Thank you all, it worked! Two nights of frustration solved within 5 minutes thanks to DDF.

Offline lubaby

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Jun 2010
  • Posts: 3159
  • Total likes: 45
  • DansDeals.com Hat Tips 12
  • Gender: Male
    • View Profile
  • Location: New York
  • Programs: Hertz PC, National EE
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.
Once the game is over, the king and the pawn go back in the same box.

Offline chucksterace

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 6801
  • Total likes: 3
  • DansDeals.com Hat Tips 40
  • Gender: Male
    • View Profile
    • Flight Lynx
  • 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 or liable for any actions taken that was recommended from my account or username.

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 6209
  • Total likes: 34
  • 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: 6209
  • Total likes: 34
  • 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 Lifetime Platinum Elite
  • *******
  • Join Date: Mar 2011
  • Posts: 2423
  • Total likes: 3
  • 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: 5006
  • Total likes: 2
  • DansDeals.com Hat Tips 66
    • 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: 6209
  • Total likes: 34
  • 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?

Offline etech0

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

Offline etech0

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