[mso] Re: was excel sort problem, now convert to access problem...
- From: Jim <n1jmm@xxxxxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Fri, 10 Jan 2003 16:59:33 -0500
it was about 4am when I was trying your 'trick' Linda, I figured I
wasn't doing something quite the way you meant...
I just wish excel would leave the column formats the way I set them,
having to reset them every time I open the sheet is most annoying...
I'm working on a 'solution', just as soon as I can get all the bugs out
of the spreadsheet it will be in access, I just don't know how to make
access SHOW me what it doesn't like about the spreadsheet when I try to
import it, it puts up error msg's that there is a problem, but doesn't
tell me where or what the problem is... I expected there would be a tool
/ method to see what the errors where so I'd know what to fix...
Thanks
-Jim-
Linda F. Johnson wrote:
>Yep....like I said, every time I've seen a sorting problem, it was either
>becuz the formats were different or there was an excess space
>somewhere....so if some of the entries are text and some are general or
>numbers, the sort won't work.
>
>That's why I told you to do what I said...that would quickly change them all
>to numbers. And no, you didn't do it right. I didn't tell you to paste the
>1 down 20 columns....I told you to COPY the 1, then select the list of
>numbers that aren't sorting correctly...then select Paste Special from the
>Edit menu and choose "Multiply"....this would multiply all of your numbers
>by 1 and therefore change them all to the number format.
>
>But...I'm glad you got it figured out. Excel's sorting feature is actually
>very flawless...as long as the format of all the numbers is the same.
>
>Linda
>Publisher ~ ABC ~ All 'Bout Computers
>Owner ~ Linda's Computer Stop
>http://personal-computer-tutor.com
>FREE MS Office eBook Tutorial
>http://personal-computer-tutor.com/library.htm
>
>
>
>-----Original Message-----
>From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
>Of Jim
>Sent: Friday, January 10, 2003 5:08 AM
>To: mso@xxxxxxxxxxxxx
>Subject: [mso] Re: excel sort problem
>
>
>
>I tried to do as you suggested but I'm not so sure what I did was what
>you meant..... I put a 1 in a new column, copied and pasted it down
>20plus cells. Then I selected all those cells and did the paste special
>multiply and I saw a Sum=28 in the bar at the bottom of the excel
>window, other than that I saw no change..
>
>Anyhow, I think I figured out what was happening this afternoon...
>
>I had started this spreadsheet like many others in the past, I'd get
>statrted, save the file, close the program, come back to it later, open
>spreadsheet by double clicking the file name in windows explorer.
>The sheet opens and I start adding more entries to it (in this case it
>is for inventory, physically adding entries for each item I find in the
>crib).
>
>
>*************************************************************
>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:
- » [mso] Re: was excel sort problem, now convert to access problem...
