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:
http://upload.turbosport.co.uk/getpi...1735355693.jpg 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. |
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: http://upload.turbosport.co.uk/getpi...5459688793.jpg 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] |
Its Just straight substution of all the little formulae into one big one....
=(Hour(F14)*60+MINUTE(F14))*0.1 Deano |
All times are GMT +1. The time now is 04:03 AM. |
© 2024 MH Sub I, LLC dba Internet Brands