Sir..
I have to buy a new version of microsoft excel, word, power point && outlook etc.I want this softwares for my highier study. so kindly give tthe link for this software. I think you are able to solve my problem. please reply me.
Not familiar with Mac but if you simply copy it (the data)and paste to a new spreadsheet that might work. In windows you can unprotect it....so another option...assuming you can't do that in Mac would be to export it to Windows....do it and the send it back to Mac. Suggest you check your help dialogues as well...should not be an insurmountable problem. Hope this helps...Tango.
The short of it is this ... Match the data in each location and store it the same way. As a number or as a string. I would say, looking at your data, that these are probably strings of numbers. Put the apostrophe in front of both pieces of data at both locations so they match. I tried a simple test in Excel and adding the apostrophe in front of all the uses of this data will match everything.
The long of it is this ... Now, I don't know your technical expertise, but I'll try to put it simply. The hard part to understand in database and data storage, is that not all numbers are numbers.
For example, a phone number 8005551212 is not a number. It's a string of numbers. This is because every single position from the 8 to the 2 is a significant position. Another example is a a social security number. The arbitrary SSN of 002003421 is a string of numbers. The first two 0's will be stripped off in Excel if put in as a number, thus ALL number but be retained in their original significant position.
The apostrophe (added by the user) forces Excel interpret the cell data as a string, instead of number, preserving all the characters in their original form, and doesn't try and tinker with the formatting.
The other reason is that the data you've provided is WAY BIG for a number. Not a lot of systems in the world will do calculations against such big numbers. This is why I "guess" that they should be strings (adding the apostrophe to the front of the data in the cell).
How do you know if data should be stored as a string or as a number.
The tall tale question is "will I be using these numbers in
calculations." If you do, it's a number, if not, it's a string (add the
apostrophe). A second question could be "do I need all positions to
retain their original information" as a literal.
First locate SCROLL LOCK key in keyboard (Normally it in function keys in laptop, and separate on desktop keyboard).
Now press:-
1. SCROLL LOCK Key
or
2. Fn + SCROLL Lock key (if it is colored as the color of Fn key in laptop)
go google and type in -- user manual for excel--- there are some site that cover the whole manual all 900 odd pages and some sites that deal with specific areas
some are pdf versions so you can down load the section that you want rather then the whole publication
another google search is --libra office cal-search--- which is a free excel user manual, and I found to be better than microsoft excel and it uses the same terms and formula and the whole publication is free
again you can read the publication until you come to the chapter on macro and print out the pages that you want free
worth the read if you are a microsoft person
right-click the sheet you want to copy, select "copy to", then either select the position within the current document, select annother document (needs to be open in the same excel instance) or select "new document". check the box "copy" to copy, leave unchecked to move.
Hello Anonymous
Refer to the following video for a complete step by step tutorial on how to create a searchable drop down list in excel. This will work with Excel version 2007 and above
If you need any further assistance, let me know.
Thanks
When you've bought it you were supposed to be given a code (on the CD sticker), if that was done over the Internet rhey're supposed to send you activation through your e-mail.
A small car is easier to handle. A used one that has a few dings so a bump into a post doesn't matter. One with bumpers that stick way out and has the original airbag. Start out in large totally empty parking lots. Sometimes an empty lot with a little snow on the ground can take the seriousness out of it for some learners. Reassure them that the brake is always there and keep your hand ready to pull the emergency brake or turn off the key for them as added reassurance. Remind them that driving is a privilege and that its always best to be predictable. Don't try teaching them on first avenue or Friday night. Perhaps make them fix any damage so they don't make a second mistake. Perhaps try at a simulator in a gamestop...