fractions turn into dates when pasting in excel 2003
 

when pasting data from a web page [ Metric/Inch Conversion] into excel,
fractions turn into dates. The same chart pastes perfectly into word but
wont copy from word into excel with out the fractions changing into dates.
and I cannot change the dates back to fractions ie 1/64 turns into Jan-64
which converts to 23377
Thanking you in advance

Hi
If you change cell format to text in excel and then copy from word and
select pastespecial and as text when pasting
seems to work for me
Tina

"Eddie Spaghetti" wrote:

when pasting data from a web page [ Metric/Inch Conversion] into excel,
fractions turn into dates. The same chart pastes perfectly into word but
wont copy from word into excel with out the fractions changing into dates.
and I cannot change the dates back to fractions ie 1/64 turns into Jan-64
which converts to 23377
Thanking you in advance

Have you tried formatting as fractions first # ??/??

--
HTH

Bob Phillips

"Eddie Spaghetti" wrote in
message ...
when pasting data from a web page [ Metric/Inch Conversion] into excel,
fractions turn into dates. The same chart pastes perfectly into word but
wont copy from word into excel with out the fractions changing into dates.
and I cannot change the dates back to fractions ie 1/64 turns into
Jan-64
which converts to 23377
Thanking you in advance

Yes I have I tried formatting a number of ways to no avail the web page is
http://www.microprecision.com/chart_metric.php
it does paste into word with NO problems and for now I have the table in word

I would like to know how to overcome this in the future

Thank you Ed

"Bob Phillips" wrote:

Have you tried formatting as fractions first # ??/??

--
HTH

Bob Phillips

"Eddie Spaghetti" wrote in
message ...
when pasting data from a web page [ Metric/Inch Conversion] into excel,
fractions turn into dates. The same chart pastes perfectly into word but
wont copy from word into excel with out the fractions changing into dates.
and I cannot change the dates back to fractions ie 1/64 turns into
Jan-64
which converts to 23377
Thanking you in advance

What does work is formatting excel as text then from word pasting special as
text [as was suggested by tina] buit why doesnt it work directly into excel ??

"Eddie Spaghetti" wrote:

Yes I have I tried formatting a number of ways to no avail the web page is
http://www.microprecision.com/chart_metric.php
it does paste into word with NO problems and for now I have the table in word

I would like to know how to overcome this in the future

Thank you Ed

"Bob Phillips" wrote:

Have you tried formatting as fractions first # ??/??

--
HTH

Bob Phillips

"Eddie Spaghetti" wrote in
message ...
when pasting data from a web page [ Metric/Inch Conversion] into excel,
fractions turn into dates. The same chart pastes perfectly into word but
wont copy from word into excel with out the fractions changing into dates.
and I cannot change the dates back to fractions ie 1/64 turns into
Jan-64
which converts to 23377
Thanking you in advance

Hi
Eddie
I don't know why formatting to text does not work but if you save excel
spreadsheet as text document then pastespecial as text save file reopen as
text delimiter tick tab space and select next fractions column to text
afterwards save as .xls file though probably quicker to copy from word
Tina

"Eddie Spaghetti" wrote:

What does work is formatting excel as text then from word pasting special as
text [as was suggested by tina] buit why doesnt it work directly into excel ??

"Eddie Spaghetti" wrote:

Yes I have I tried formatting a number of ways to no avail the web page is
http://www.microprecision.com/chart_metric.php
it does paste into word with NO problems and for now I have the table in word

I would like to know how to overcome this in the future

Thank you Ed

"Bob Phillips" wrote:

Have you tried formatting as fractions first # ??/??

--
HTH

Bob Phillips

"Eddie Spaghetti" wrote in
message ...
when pasting data from a web page [ Metric/Inch Conversion] into excel,
fractions turn into dates. The same chart pastes perfectly into word but
wont copy from word into excel with out the fractions changing into dates.
and I cannot change the dates back to fractions ie 1/64 turns into
Jan-64
which converts to 23377
Thanking you in advance