| We hope you enjoy your visit. You're currently viewing our forum as a guest. This means you are limited to certain areas of the board and there are some features you can't use. If you join our community, you'll be able to access member-only sections, and use many member-only features such as customizing your profile, sending personal messages, and voting in polls. Registration is simple, fast, and completely free. Join our community! If you're already a member please log in to your account to access all of our features: |
| Excel Help | |
|---|---|
| Topic Started: Jul 31 2009, 03:00 PM (51 Views) | |
| FMPBeats | Jul 31 2009, 03:00 PM Post #1 |
|
Anyone who knows Excel well, I have a small problem I need help with. I won't bother giving the details of the whole 'project', but basically I have to make an Excel file that you just have to copy and paste a table in and it does a load of stuff to it lol. The problem I have, is that in the table the values are scores, and they are in the format of 4–3. I had to get each them into separate boxes so I can work with them, and I figured that part out by using 'left' and 'right' formulas or whatever they are called. Here's the problem, after doing that they are now considered text and not numbers, so I can't do stuff like auto sum or anything on them. I need either a formula that convert them to the number form, or an alternative to '=left' and '=right' that keeps them in numbers. I know I could easily do it manually, but it has to be done so that all you have to do is copy and paste a table in the beginning and everything between that and the end result is automated. Any ideas? Edited by FMPBeats, Jul 31 2009, 03:01 PM.
|
 |
 
|
| FMPBeats | Jul 31 2009, 03:59 PM Post #2 |
|
nvm figured it out |
|
|
|
| 1 user reading this topic (1 Guest and 0 Anonymous) | |
| « Previous Topic · Advice · Next Topic » |
5:24 AM Nov 27
