LinkBack URL
About LinkBacks
View Profile
View Forum Posts
Private Message
View Blog Entries
Visit Homepage
View Articles
Reply With QuoteI know on excel you can "paste special" (right click) then set it to paste values only - not sure if it works in a CSV but worth a try?
Okay...this time I'm trying to copy prices from an excel spreadsheet into a CSV file. I have a formula in the excel spreadsheet which is basically price plus 50% plus 4, however when I try to copy and paste the prices into the CSV file all I get is the 4 showing in each column. I take it this is because the forula is linked in the original spreadsheet to another number? How can I get around this so I can just copy and paste the prices without having to retype them all in the CSV file???
I know on excel you can "paste special" (right click) then set it to paste values only - not sure if it works in a CSV but worth a try?
Sara Parr
Above Parr PA Services - Virtually Everything Done For You!
www.aboveparr.co.uk
Follow me on www.twitter.com/aboveparr
PremierPDS (02-07-2009)
Thanks Sara, that's done the trick and I'm away... and could be gone quite some time lol! Bloomin databases...I hate them already and I've only just started!!!
OrOriginally Posted by PremierPDS
Okay...this time I'm trying to copy prices from an excel spreadsheet into a CSV file. I have a formula in the excel spreadsheet which is basically price plus 50% plus 4, however when I try to copy and paste the prices into the CSV file all I get is the 4 showing in each column. I take it this is because the forula is linked in the original spreadsheet to another number? How can I get around this so I can just copy and paste the prices without having to retype them all in the CSV file???
Once you have the info you want to transfer, save the excel file as a complete csv file named MASTER. FILE > SAVE AS > OTHER FORMATS > CSV
Then re-open it, delete what you do not want and save as owt you like and you always have the csv MASTER file for reference and to update.
Using csv is a great way to get your products portable in today's multi cart environment and and an area I am happy to post about as it is one of my specialities...
I know geek alert
HTH
Web design in Leicester serving the U.K.
Web design forum now online to solve your little issues.
Become a fan of mine on Facebook...you know you wanna
PremierPDS (02-07-2009)
Sounds like a plan although if I delete the info and it's linked to the prices I do want then all I'll be left with is the number 4 as before if you get my meaning lol!
No, by saving as a CSV file you will remove all formulas and just save the actual figures. So then you can remove the linked info and the calculated column will stay as it should be.Sounds like a plan although if I delete the info and it's linked to the prices I do want then all I'll be left with is the number 4 as before if you get my meaning lol!
Rob
Funky Raw - Helping you eat a healthier diet
My Blog - Raw food recipes and wild food - Learn how to make healthy food that tastes great
Healthy Chocolate
Just to clarify, when you save an excel file to csv, all the formula is gone. All that will save is the result.Sounds like a plan although if I delete the info and it's linked to the prices I do want then all I'll be left with is the number 4 as before if you get my meaning lol!
Web design in Leicester serving the U.K.
Web design forum now online to solve your little issues.
Become a fan of mine on Facebook...you know you wanna
Beat me
Web design in Leicester serving the U.K.
Web design forum now online to solve your little issues.
Become a fan of mine on Facebook...you know you wanna
Arh....whoooooooooohooooooooo, it's all rocket science to me lol! Thanks guys, I didn't know that, only recently started working in Excel and with CSV files so I'm a bit lost and that's defo a good thing to know...now it really does sound like a plan lol!!!
