bjjsmith69
New Member
- Joined
- Jan 2, 2021
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
I am a dropshipper and use excel for everything what iI can't Figuer out is how to convert a decimal weight to pounds and ounces. I needs the pounds in one colum and the oz in another. the other issue i have is wil over 1 milling images file names i need to be able to have excel highlight the Duplect filenames so that i may remove only the onnes they are not Duplect example shown below of my excel sheet
NUMBER | INETSDESC | INETSHORTD | UNITS | UNITWEIGHT | LBS | OZ | Wholesale | PRICE1 | DELDATE | DISCONT | INETIMAGE | CANTSELL | blength | bwidth | bheight |
A4499GU | Guardian Angel pocket stone | This small stone is inscribed with an Angel and is quite useful in meditation and prayer. One amulet with an angel on one side and the word “Guardian” on the other. Pewter. Made in USA. 1” x 5/8” | 29 | 0.01 | 3.5 | 0 | A4499GU.jpg | 0 | 3.8 | 3 | 0.3 | ||||
A4499LO | Love Angel pocket stone | This small stone is inscribed with an Angel and is quite useful in meditation and prayer. One amulet with an angel on one side and the word “Love” on the other. Pewter. 1” x 5/8”. Made in USA | 26 | 0.01 | 3.5 | 0 | A4499LO.jpg | 0 | 3.8 | 3 | 0.3 | ||||
A4499PE | Peace Angel pocket stone | This small stone is inscribed with an Angel and is quite useful in meditation and prayer. One amulet with an angel on one side and the word “Peace” on the other. Pewter. 1” x 5/8”. Made in USA | 50 | 0.01 | 3.5 | 0 | A4499PE.jpg | 0 | 3.8 | 3 | 0.3 | ||||
A4502A | Angel pocket stone | Embossed with a angel, this pocket stone functions as a powerful focus during your ritual magic and meditation. Pewter. 1" x 5/8" Made in USA | 44 | 0.03 | 2.95 | 0 | A4502At.jpg | 0 | 3.8 | 3 | 0.3 | ||||
A4502B | Buddha pocket stone | This pewter pocket stone bears the image of the Buddha. This is intended to remind you to seek inner peace and the middle way in all things. Pewter. 3/4". Made in USA | 90 | 0.03 | 2.95 | 0 | A4502B.JPG | 0 | 3.8 | 3 | 0.3 | ||||
A4502C | Clover pocket stone | A favorite token of good luck, the four leaf clover, has been engraved in this pocket stone. Carry it with you for good luck. Pewter. 5/8" x 1" Made in USA | 117 | 0.03 | 2.95 | 0 | A4502C.jpg | 0 | 3.8 | 3 | 0.3 | ||||
A4502CR | Cross pocket stone | The cross pocket stone features the cut out of a cross in a pewter stone. Pewter. 1" x 5/8" Made in USA | 92 | 0.03 | 2.95 | 0 | A4502CR.jpg | 0 | 3.8 | 3 | 0.3 | ||||
A4502GO | Goddess pocket stone | The Goddess Pocket stone is a great focus to help you stay in tune with the divine feminine or help guide you through your meditations. Pewter. 1" x 5/8" Made in USA | 101 | 0.03 | 2.95 | 0 | A4502GO.jpg | 0 | 3.8 | 3 | 0.3 | ||||
A4502H | Heart pocket stone | A small, heart shaped, pewter pocket stone decorated with tiny swirls. Pewter. 1" x 5/8" Made in USA | 245 | 0.03 | 2.95 | 0 | A4502H.jpg | 0 | 3.8 | 3 | 0.3 |