mj

Well, easy for you lot anyway. I need to pase our online phone bills into a worksheet to allow me to further sort them ( i have this bit sussed of a fashion)When I paste the data in from the phone site it reatins its formatting, as HTML and uses different fonts, alignments ,fill colours etc as below:



I have formatted all the cells in the sheet to how I want them but it still overwrites and does its own thing. ( I tried paste special with text and unicode-no good either)

Is there an option in Excel to preserve formatting - if there is I cant see it.

mj

thanks for all rushing to solve my little quandry, I sussed it eventually, "match destination formatting" apparently.

any way the next connundrum is as follows. Our package is approx 1500 free minutes for £150, or about 10p per minute.Below is what I have done to convert the duration for the call into pound notes, in short we need to pass on the costs of our "free" calls to the users,myself included:



ETS: J,K,L,M are what I have added to the stuff pasted in.
How can I simplify this lot into one cell?

Ta,

Mike.



[Edited by mj - 12/13/2002 12:12:11 AM]

dsmith

Its Just straight substution of all the little formulae into one big one....

=(Hour(F14)*60+MINUTE(F14))*0.1

Deano