Search results

Again thanks I'm loving the learning x

Thanks Dave it does sound a bit complex so I'll do my bit as of todays rate and let the powers that be decide if they want this changed before quoting. If I was to convert the opposite way, ie £ to Euro would I divide the current rate rather than multiply?

thanks Dave, is there anyway that it can automatically update based on the daily rate or would this be to complicated?

how do you convert a price list that is in euro to £ thanks

cheers x

Hi Jason yeah l would like it to look like S-XXL etc... I can keep the info and hide the Colum or just replace the existing. Another query I have (sorry) do you know how I ensure my first two rows are printed on each sheet? Thanks

Small - XX Large Small -X Large Small -Large Small -XX Large Small-Medium/Large Small - XX Large Small -XX Large Small -X Large need to change to S-XXL and so forth, is this possible?

Hui - Mwahhh I could hug ya thank you so much xx

I have a supplier price manual (3000 plus rows)with product numeric codes ie 12345, my own internal codes should begin with an abbreviated 3 digit alpha code ie ABC12345 does anyone know how I can change this without having to do each individually? As always your help is appreciated.

Dave thanks, you have no idea how much work this will save me.

Thanks so much for this, which is fabulous however it rounds up as you say to 1 decimal place is this possible to have is as say £71.81 rounded to £71.85?

Thanks so much for this, which is fabulous however it rounds up as you say to 1 decimal place is this possible to have is as say £71.81 rounded to £71.85?

Can anyone help please I have a huge spread sheet I need to round up the pennies on, I've started to do this manually but it is going to take me till my pension and I do know that excel has the capabilities of doing this I just can't work out how and would appreciate any advise, see below, first...