I have a spreadsheet designed to calculate material costs for certain products. the materials remain constant but the prices change frequently...what I need is to be able to change prices (several at once) without changing the material quantity. So, say I have a price of $3.11 for a certain product but I also have a material quantity of 3.11, how do I change the $3.11 without changing the 3.11?
Keep in mind that there will be multiple cells with the same number that needs changed.
Thanks
Tom
find and replace option??
in find what -> right side you'll see an option "Format" click that then choose currency
in replace with ->do same aboce ->choose "Format" click then choose currency
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Awesome, thanks. Never even thought to look there. Works just fine now.
Tom
Nice.
Regards,
Vlady
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks