Guest blacknightcomputers Posted December 7, 2005 Share Posted December 7, 2005 Hi i have a Spread sheet that has the prices from my suppler and a colum in there that i add so that i can add on say £5 to all the suppliers prices so that i get £5 profit from the sale etc i do this as a formule and then copy the colum in to the other spread sheet i have with all the information that the CSV UPloader needs in the form of a spread sheet.. i copy the colum for my profit in to the normal price colum but it pasts the formula not hte figars that the formula works out is there a way to just copy the figars that the formula works out ???? Hope this makes sence .... Regards Phillip Cooper Quote Link to comment Share on other sites More sharing options...
Guest Posted December 7, 2005 Share Posted December 7, 2005 I dont think so. but then again i dont use excel that much. Quote Link to comment Share on other sites More sharing options...
Guest Posted December 7, 2005 Share Posted December 7, 2005 Hi This can be done by using the paste special function... Copy the cell you want then move to the other spreadsheet right click in the cell and click paste special then select values. Hope this helps A Quote Link to comment Share on other sites More sharing options...
Guest blacknightcomputers Posted December 7, 2005 Share Posted December 7, 2005 Hi i tried that and pasted the prices in to the spreadsheet and uploaded useing CSV Uploader... but once the products are on the site the price comes up as 0.00 ????? any ideas?????? Regards Phillip Cooper Quote Link to comment Share on other sites More sharing options...
Guest estelle Posted December 7, 2005 Share Posted December 7, 2005 If the prices look fine in the spreadsheet, but are turning out to be zero after being imported, then something else is going wrong. Perhaps the prices are incorrect after the spreadsheet is saved as a CSV file (unlikely)? Perhaps the price column is in the wrong spot? Etc.. Quote Link to comment Share on other sites More sharing options...
Guest blacknightcomputers Posted December 7, 2005 Share Posted December 7, 2005 but if it was in the colum was in the wrong place then the prices that i have had on there previouly would not have shown either???? Still need help on this..??? please people Quote Link to comment Share on other sites More sharing options...
Guest estelle Posted December 7, 2005 Share Posted December 7, 2005 Have you had a good look at the output CSV file to check that nothing obvious is wrong with it? Quote Link to comment Share on other sites More sharing options...
Guest blacknightcomputers Posted December 7, 2005 Share Posted December 7, 2005 Worked it out, when i copied the data it was Putting the " £ " sign in front of the number and the field that it was up loading it to will only support prices in the format "0.00" and not "£0.00" ..... Sorry to be a pain Regards Phil Quote Link to comment Share on other sites More sharing options...
Guest Posted December 7, 2005 Share Posted December 7, 2005 save everyone some reading next time and just post a few rows from the spread sheet :D Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.