Pasting #-# as text and not a date
 

I'm trying to paste a series numeric data entered in the format ##-## into
another spreadsheet as text and not convert any to dates. No matter what I've
done so far, Excel converts any entry it can interpret as a date into a date.


For example:
2-18 0-18 12-33 3-36 7-32 0-60
pastes as
38766 0-18 12389 13210 11871 0-60

I need it to paste in its original state as text so that I can extract the
numbers before the - into a different row and then the numbers after the -
into another row.

Any ideas?
--
lcshrm

Pasting #-# as text and not a date
 

Have you tried paste special - value and formats?
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"lcshrm" wrote:

I'm trying to paste a series numeric data entered in the format ##-## into
another spreadsheet as text and not convert any to dates. No matter what I've
done so far, Excel converts any entry it can interpret as a date into a date.


For example:
2-18 0-18 12-33 3-36 7-32 0-60
pastes as
38766 0-18 12389 13210 11871 0-60

I need it to paste in its original state as text so that I can extract the
numbers before the - into a different row and then the numbers after the -
into another row.

Any ideas?
--
lcshrm

Pasting #-# as text and not a date
 

Hi,

First change the cells format to text and then enter the data.

Thanks,
--
Farhad Hodjat


"lcshrm" wrote:

I'm trying to paste a series numeric data entered in the format ##-## into
another spreadsheet as text and not convert any to dates. No matter what I've
done so far, Excel converts any entry it can interpret as a date into a date.


For example:
2-18 0-18 12-33 3-36 7-32 0-60
pastes as
38766 0-18 12389 13210 11871 0-60

I need it to paste in its original state as text so that I can extract the
numbers before the - into a different row and then the numbers after the -
into another row.

Any ideas?
--
lcshrm

Pasting #-# as text and not a date
 

Tried that. Get the same results.
The spreadsheet from which I'm copying data was generated from an XML source
file.

--
lcshrm


"John" wrote:

Have you tried paste special - value and formats?
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"lcshrm" wrote:

I'm trying to paste a series numeric data entered in the format ##-## into
another spreadsheet as text and not convert any to dates. No matter what I've
done so far, Excel converts any entry it can interpret as a date into a date.


For example:
2-18 0-18 12-33 3-36 7-32 0-60
pastes as
38766 0-18 12389 13210 11871 0-60

I need it to paste in its original state as text so that I can extract the
numbers before the - into a different row and then the numbers after the -
into another row.

Any ideas?
--
lcshrm

Pasting #-# as text and not a date
 

Tried that, pasting only the values, but still get the same results.
Anyone else have an idea?

--
lcshrm


"Farhad" wrote:

Hi,

First change the cells format to text and then enter the data.

Thanks,
--
Farhad Hodjat


"lcshrm" wrote:

I'm trying to paste a series numeric data entered in the format ##-## into
another spreadsheet as text and not convert any to dates. No matter what I've
done so far, Excel converts any entry it can interpret as a date into a date.


For example:
2-18 0-18 12-33 3-36 7-32 0-60
pastes as
38766 0-18 12389 13210 11871 0-60

I need it to paste in its original state as text so that I can extract the
numbers before the - into a different row and then the numbers after the -
into another row.

Any ideas?
--
lcshrm

Pasting #-# as text and not a date
 

Tried that, pasting only the values, but get the same results.

Anyone have another suggestion?

--
lcshrm


"Farhad" wrote:

Hi,

First change the cells format to text and then enter the data.

Thanks,
--
Farhad Hodjat


"lcshrm" wrote:

I'm trying to paste a series numeric data entered in the format ##-## into
another spreadsheet as text and not convert any to dates. No matter what I've
done so far, Excel converts any entry it can interpret as a date into a date.


For example:
2-18 0-18 12-33 3-36 7-32 0-60
pastes as
38766 0-18 12389 13210 11871 0-60

I need it to paste in its original state as text so that I can extract the
numbers before the - into a different row and then the numbers after the -
into another row.

Any ideas?
--
lcshrm