Pasting HTML script to Excel 2007 converts the cells format to 'General'

D

DileepReddy

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 tha
contains '.234567' (as shown below), Excel converts the cell's format t
'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 ta
that I can use as part of HTML code or something I can do in EXCEL t
make this work?
Please reply ASAP

Thanks,
Dilip

PS: '.234567' here represents the frequency in a wee
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

convertin html format to number format 2
Excel freezes after paste HTML from IE 0
Is Paste Special HTML broken in Excel/Office 2007? 1
How do I get HTML codes in an Excel Spreadsheet to display or conv 2
Page Format lost while saving to html 0
Getting Warning when I try to open excel in 2007. 0
Getting Warning when I try to open ecxel in 2007. 0
text converts to scientific 1

Top