Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Default Pasting HTML script to Excel 2007 converts the cells format to 'General'

Hi,

When I convert a cell's format to 'Text' & paste the text '.234567', Excel retains the format & shows '.234567'.

But when I convert the cell's format to 'Text' & paste HTML code that contains '.234567' (as shown below), Excel converts the cell's format to 'General' & shows '0.234567'

<html<body<STYLE TYPE=\"text\plain"</STYLE.234567</body</html

I tried with different STYLE TYPES but didn't work. Is there any tag that I can use as part of HTML code or something I can do in EXCEL to make this work?
Please reply ASAP

Thanks,
Dilip

PS: '.234567' here represents the frequency in a week
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
pasting html table into excel rodchar Excel Discussion (Misc queries) 0 March 27th 09 03:26 PM
Excel 2007 pasting creates too many cells Steve300 Excel Discussion (Misc queries) 0 March 13th 07 10:21 PM
pasting a html table into excel TK Excel Discussion (Misc queries) 2 August 24th 06 06:43 PM
Pasting HTML into the cells in column A Colin Hayes Excel Worksheet Functions 2 July 23rd 06 02:12 AM
Pasting from web into Excel - Excel converts into mathmatical - how to prevent David Smithz Excel Discussion (Misc queries) 7 March 6th 06 05:52 PM


All times are GMT +1. The time now is 05:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"