[mso] Re: Pasting data into excel, problem
- From: Glenda Wells <gwells@xxxxxxxxxxx>
- To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx>
- Date: Thu, 16 Jan 2003 15:00:35 -0500
Try doing a paste/special/text. That worked on a similar problem I had
recently. /g
-----Original Message-----
From: Hough, John [mailto:jhough@xxxxxxxxx]
Sent: Thursday, January 16, 2003 2:19 PM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Re: Pasting data into excel, problem
Anyone else have any suggestions on this? Thanks.
-----Original Message-----
From: Hough, John [mailto:jhough@xxxxxxxxx]
Sent: Wednesday, January 15, 2003 9:21 AM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Pasting data into excel, problem
I'm trying to paste in some data from a website into excel and am having a
little issue. One of the columns of data is formatted like this - 1/3 or
2/4 or 0/3 etc. When I paste it into excel it converts the data to a date
string (3-Jan, 4-Feb, etc). Any column with the 0 in front goes in as it
should, but the others all convert to a date, how can I convert it back to
the original number or retain the original formatting? I tried formatting
the cell(s) as a fraction or plain text but that just made it a big number.
Any suggestions? Thanks.
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
Or, visit the group's homepage and use the dropdown menu. This will also
allow you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation
with instructions. Once you are a member of the files group, you can go
here to upload/download files: http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
Or, visit the group's homepage and use the dropdown menu. This will also
allow you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation
with instructions. Once you are a member of the files group, you can go
here to upload/download files: http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
