Excel Help and Problems

[bubbles]

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

[churnbabychurn]

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?

[smurf]

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.

Table	A	B	C
1	A1-600
2		B601-1200
3			C1201-1800

It sounds like your data looks like this

[chff]

For some reason, when I create a new sheet, the page name on the bottom is in Hebrew. How can I change it?

[dave]

how do i trun off  scientific notation?

[aygart]

how do i trun off  scientific notation?

meaning when you enter a long number?

[dave]

yes all data i enter should be  as is

[aygart]

Do you need it to be considered a number by excel such as to do calculations from

[Marco Polo]

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).

[dave]

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 =

[Centurion]

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

[dave]

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

[aygart]

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.

[dave]

thanks so much it worked

[aygart]

I go through this all the time with utility account numbers

[A3]

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

[AnonymousUser]

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.

[Fan of Dan]

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

[churnbabychurn]

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

[etech0]

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

+1