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

Offline bubbles

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2011
  • Posts: 5082
  • Total likes: 20
  • DansDeals.com Hat Tips 67
    • View Profile
Re: Excel Problem
« Reply #200 on: July 16, 2014, 11:45:42 PM »
I think posting a small example might help. It sounds like the type of problem with an easy fix, but I'm still not exactly sure how it looks

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7647
  • Total likes: 301
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #201 on: July 17, 2014, 12:28:09 AM »
Hi,
I ran a report at work and it divided the rows up into 3 sets of 600 rows instead of 1 wide row of 600. Is there any way to put them side by side matching the user Id of each row.
Please let me know if I can be any clearer. Tia
Ran a report from where?

Offline smurf

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Sep 2010
  • Posts: 4555
  • Total likes: 301
  • DansDeals.com Hat Tips 8
    • View Profile
  • Location: NJ
Re: Excel Problem
« Reply #202 on: July 17, 2014, 12:56:17 AM »
It split column a,b,c rows 1-600 into column a 1-601 b 601-1200 c1201-1800. I put them side by side but they are not all exactly the same. I want to match them up by the id number at the beginning of each row.
TableABC
1A1-600
2B601-1200
3C1201-1800

It sounds like your data looks like this

Offline chff

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 5940
  • Total likes: 695
  • DansDeals.com Hat Tips 25
    • View Profile
  • Location: NYC (not anymore)
  • Programs: All of them...
Re: Excel Problem
« Reply #203 on: July 17, 2014, 07:10:09 AM »
For some reason, when I create a new sheet, the page name on the bottom is in Hebrew. How can I change it?

Offline dave

  • Dansdeals Gold Elite
  • ***
  • Join Date: Nov 2011
  • Posts: 116
  • Total likes: 0
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel Problem
« Reply #204 on: August 18, 2014, 04:58:23 PM »
how do i trun off  scientific notation?

Offline aygart

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: May 2008
  • Posts: 18394
  • Total likes: 14573
  • DansDeals.com Hat Tips 14
    • View Profile
    • Lower Watt Energy Brokers
  • Programs: www.lowerwatt.com
Re: Excel Problem
« Reply #205 on: August 18, 2014, 05:02:42 PM »
how do i trun off  scientific notation?
meaning when you enter a long number?
Feelings don't care about your facts

Offline dave

  • Dansdeals Gold Elite
  • ***
  • Join Date: Nov 2011
  • Posts: 116
  • Total likes: 0
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel Problem
« Reply #206 on: August 18, 2014, 05:04:36 PM »
yes all data i enter should be  as is

Offline aygart

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: May 2008
  • Posts: 18394
  • Total likes: 14573
  • DansDeals.com Hat Tips 14
    • View Profile
    • Lower Watt Energy Brokers
  • Programs: www.lowerwatt.com
Re: Excel Problem
« Reply #207 on: August 18, 2014, 05:06:02 PM »
Do you need it to be considered a number by excel such as to do calculations from
Feelings don't care about your facts

Offline Marco Polo

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Jul 2012
  • Posts: 13126
  • Total likes: 49
  • DansDeals.com Hat Tips 104
  • Gender: Male
    • View Profile
Re: Excel Problem
« Reply #208 on: August 18, 2014, 05:06:28 PM »
yes all data i enter should be  as is
Try "trimming" the amount of decimal places shown in a cell (on the home tab in the "number" box).
Quaerite et Invenietis.

Offline dave

  • Dansdeals Gold Elite
  • ***
  • Join Date: Nov 2011
  • Posts: 116
  • Total likes: 0
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel Problem
« Reply #209 on: August 18, 2014, 05:16:13 PM »
trying to upload template to amazon keeps on giving me this error

Error A EAN/UPC value in scientific notation is not allowed: [Product ID Type = "ean"], [Product ID =

Offline Centurion

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jun 2012
  • Posts: 1310
  • Total likes: 5
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: New York / Jerusalem
  • Programs: spg plat,avis pres ,hertz plat ,AAexcutime, delta plat,hilton gold, united
Re: Excel Problem
« Reply #210 on: August 18, 2014, 05:32:41 PM »
Did you put a 1 or a 3
Did you put asin or sku?
Try ro pasre in note pad first then back in excel
If it doesn't show a number you will get this error
you can only make a first impression ONCE

Offline dave

  • Dansdeals Gold Elite
  • ***
  • Join Date: Nov 2011
  • Posts: 116
  • Total likes: 0
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel Problem
« Reply #211 on: August 18, 2014, 05:37:00 PM »
Did you put a 1 or a 3
Did you put asin or sku?
Try ro pasre in note pad first then back in excel
If it doesn't show a number you will get this error

asin and sku

never had a problem before

Offline aygart

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: May 2008
  • Posts: 18394
  • Total likes: 14573
  • DansDeals.com Hat Tips 14
    • View Profile
    • Lower Watt Energy Brokers
  • Programs: www.lowerwatt.com
Re: Excel Problem
« Reply #212 on: August 18, 2014, 05:39:31 PM »
trying to upload template to amazon keeps on giving me this error

Error A EAN/UPC value in scientific notation is not allowed: [Product ID Type = "ean"], [Product ID =
as I thought it is not a "number" but text with numeric characters. Format the cells as text in excel. You may need to fake edit each cell if you are doing it after the number was entered. This means to select the cell, place the cursor in the editing area, and press enter. If you are pasting into the cells you may need to right click and paste values instead of using control v. That is the paste icon with the 123 on it.
An alternative method is to type a ' at the beginning of each number.
Feelings don't care about your facts

Offline dave

  • Dansdeals Gold Elite
  • ***
  • Join Date: Nov 2011
  • Posts: 116
  • Total likes: 0
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel Problem
« Reply #213 on: August 18, 2014, 05:51:32 PM »
thanks so much it worked


Offline aygart

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: May 2008
  • Posts: 18394
  • Total likes: 14573
  • DansDeals.com Hat Tips 14
    • View Profile
    • Lower Watt Energy Brokers
  • Programs: www.lowerwatt.com
Re: Excel Problem
« Reply #214 on: August 18, 2014, 05:54:51 PM »
I go through this all the time with utility account numbers
Feelings don't care about your facts

Offline A3

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Nov 2009
  • Posts: 3476
  • Total likes: 98
  • DansDeals.com Hat Tips 5
  • Gender: Male
    • View Profile
Re: Excel Problem
« Reply #215 on: September 18, 2014, 12:20:15 PM »
Hi helpful peoples.
I want to get a simple barcode reader to keep track of inventory, the only inventory I need to keep track of at the moment is finished goods, I need a few columns, such as Item, UPC, New inventory, shipped, on shelf (total)
I would want to scan a barcode and have excel do the rest.
Any ideas where to start?

Also I would want an option for the scanner to lower the inventory when the items ship out.

How complicated does this sound?

Thanks guys

Offline AnonymousUser

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Feb 2013
  • Posts: 3002
  • Total likes: 13
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel Problem
« Reply #216 on: September 18, 2014, 03:00:02 PM »
Hi helpful peoples.
I want to get a simple barcode reader to keep track of inventory, the only inventory I need to keep track of at the moment is finished goods, I need a few columns, such as Item, UPC, New inventory, shipped, on shelf (total)
I would want to scan a barcode and have excel do the rest.
Any ideas where to start?

Also I would want an option for the scanner to lower the inventory when the items ship out.

How complicated does this sound?

Thanks guys
You can write a macro to get input from the barcode scanner, lookup the row with that item, and decrease the quantity in stock by 1.

Offline Fan of Dan

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: May 2011
  • Posts: 3029
  • Total likes: 8
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel Problem
« Reply #217 on: September 18, 2014, 03:30:54 PM »
Don't want this to come across as if I think excel is simple or easy to learn. Where can I learn basic excel either online or perhaps a good book etc. I use it a bit for simple stuff and I think know I am not taking advantage of what it has to offer properly.

Thank you

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7647
  • Total likes: 301
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #218 on: September 18, 2014, 03:34:04 PM »
Hi helpful peoples.
I want to get a simple barcode reader to keep track of inventory, the only inventory I need to keep track of at the moment is finished goods, I need a few columns, such as Item, UPC, New inventory, shipped, on shelf (total)
I would want to scan a barcode and have excel do the rest.
Any ideas where to start?

Also I would want an option for the scanner to lower the inventory when the items ship out.

How complicated does this sound?

Thanks guys
you really need a cheap POS/inventory system. Using excel sounds complicated when there is an abundance of other options.. IMHO

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12918
  • Total likes: 3371
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Problem
« Reply #219 on: September 18, 2014, 03:38:21 PM »
you really need a cheap POS/inventory system. Using excel sounds complicated when there is an abundance of other options.. IMHO
+1
Workflowy. You won't know what you're missing until you try it.