[mso] Pasting data into excel, problem
- From: "Hough, John" <jhough@xxxxxxxxx>
- To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx>
- Date: Wed, 15 Jan 2003 09:20:39 -0800
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
*************************************************************
Other related posts:
