What if you format the cells as Text, and then paste the code.

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Brennanb" wrote:

> I wish to create an archive of css and html code and store it in a
> spreadsheet for sorting reuse etc but find the code is automatically
> rendered as n a browser window, please is ther any wat to format cells so
> this will not happen, suggestions for alternative or help in solving the
> problem will be greatly appreciated with thanks brennanb
>

Thank, you for your time, I did as you advised and got the html pasted, next
problem was it was pasted int a range of rows any ideas on this hitch
appreciated thanking you Brennanb--
Brennanb


"Wigi" wrote:

> What if you format the cells as Text, and then paste the code.
>
> --
> Wigi
> http://www.wimgielis.be = Excel/VBA, soccer and music
>
>
> "Brennanb" wrote:
>
> > I wish to create an archive of css and html code and store it in a
> > spreadsheet for sorting reuse etc but find the code is automatically
> > rendered as n a browser window, please is ther any wat to format cells so
> > this will not happen, suggestions for alternative or help in solving the
> > problem will be greatly appreciated with thanks brennanb
> >

Check out the Paste special options you have, but I don't think you can put
in 1 cell (if that's what you want).

Iin any case, I would think that putting it in rows makes the analysis
/storage simpler, also to copy code. (e.g. you can use Autofilter, sort
cells, ...)


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"brennanb" wrote:

> Thank, you for your time, I did as you advised and got the html pasted, next
> problem was it was pasted int a range of rows any ideas on this hitch
> appreciated thanking you Brennanb--
> Brennanb
>
>
> "Wigi" wrote:
>
> > What if you format the cells as Text, and then paste the code.
> >
> > --
> > Wigi
> > http://www.wimgielis.be = Excel/VBA, soccer and music
> >
> >
> > "Brennanb" wrote:
> >
> > > I wish to create an archive of css and html code and store it in a
> > > spreadsheet for sorting reuse etc but find the code is automatically
> > > rendered as n a browser window, please is ther any wat to format cells so
> > > this will not happen, suggestions for alternative or help in solving the
> > > problem will be greatly appreciated with thanks brennanb
> > >

Thanky you again I am using Excel 2007 and find it fussy, managed to paste
text directly into insertion line, problem posting directly to the cell,
thanks for help
--
Brennanb


"Wigi" wrote:

> Check out the Paste special options you have, but I don't think you can put
> in 1 cell (if that's what you want).
>
> Iin any case, I would think that putting it in rows makes the analysis
> /storage simpler, also to copy code. (e.g. you can use Autofilter, sort
> cells, ...)
>
>
> --
> Wigi
> http://www.wimgielis.be = Excel/VBA, soccer and music
>
>
> "brennanb" wrote:
>
> > Thank, you for your time, I did as you advised and got the html pasted, next
> > problem was it was pasted int a range of rows any ideas on this hitch
> > appreciated thanking you Brennanb--
> > Brennanb
> >
> >
> > "Wigi" wrote:
> >
> > > What if you format the cells as Text, and then paste the code.
> > >
> > > --
> > > Wigi
> > > http://www.wimgielis.be = Excel/VBA, soccer and music
> > >
> > >
> > > "Brennanb" wrote:
> > >
> > > > I wish to create an archive of css and html code and store it in a
> > > > spreadsheet for sorting reuse etc but find the code is automatically
> > > > rendered as n a browser window, please is ther any wat to format cells so
> > > > this will not happen, suggestions for alternative or help in solving the
> > > > problem will be greatly appreciated with thanks brennanb
> > > >