01 Mar 07
We use Excel for our order forms, stuff we have to buy, someone programmed our excel code a few years ago, don't know who.
So in this one field where the model number goes, in this case an order to Grainger, they have their own catalog #'s. In this one case, the Grainger # is 5E152. Now the problem is, when I type in that #, and click it in, it converts so scientific notation, 5.00E+152. I hit format cells and found it locked, so unlocked it and hit numbers. But no matter what I do in that format cell block, it always gives the scientific notation for XXEXX. I found a workaround, just enter it as 5-E152 and it does not go scientific on me. Wonder if anyone knows how I can get rid of that scientific notation since it will never be used on an order form?
01 Mar 07
Originally posted by sonhouseI don't know excel at all but my first try would be to right click on the cell and see what options you have to edit that particular square. There's my two (worthless) cents...
We use Excel for our order forms, stuff we have to buy, someone programmed our excel code a few years ago, don't know who.
So in this one field where the model number goes, in this case an order to Grainger, they have their own catalog #'s. In this one case, the Grainger # is 5E152. Now the problem is, when I type in that #, and click it in, it converts so ...[text shortened]... s how I can get rid of that scientific notation since it will never be used on an order form?
01 Mar 07
Originally posted by Mephisto2I found the answer: I was changing scientific notation to numbers in the selection list. So I tried 'text' instead. That cured the problem. It accepts it as a text file which it will not interpret mathematically. Thanks for the help. Don.
if you format the cell (or the whole column if you like) to text (right click, choose cell properties), it shouldn't convert to anything. You still can sort the fields.
01 Mar 07
Originally posted by SJ247Don't make a fool of yourself, honey.
You'd probably fix a rattle in your car by turning up the radio. You need to own an inner desire to understand and solve the real problem, rather than use duct tape, to get into Mensa.
kisses.
If you type '5E152 Excel will recognize the apostrophe as an indicator that what follows is text and will show only 5E152. Without the apostrophe. It's much faster than changing the properties of a cell.
But you knew that, didn't you?
01 Mar 07
2 edits
Originally posted by PalynkaAnyone who actually uses Excel knows that. SJ just has a hard-on for you.
Don't make a fool of yourself, honey.
If you type '5E152 Excel will recognize the apostrophe as an indicator that what follows is text and will show only 5E152. Without the apostrophe. It's much faster than changing the properties of a cell.
But you knew that, didn't you?
In fact, if sonhouse didn't know the apostorphe function in the first place, he is MUCH better off now. But I wouldn't hold your breath waiting for a thank you.
01 Mar 07
Originally posted by darvlayI seriously doubt that anything about SJ can be something other than flabby.
Anyone who actually uses Excel knows that. SJ just has a hard-on for you.
In fact, if sonhouse didn't know the apostorphe function in the first place, he is MUCH better off now. But I wouldn't hold your breath waiting for a thank you.
- Joined
- 05 Oct 05
- Moves
- 63425
01 Mar 07
Originally posted by PalynkaI know that the use of an apostrophe, in a field formatted for numbers, does not change the formatting for that field to text.
Don't make a fool of yourself, honey.
If you type '5E152 Excel will recognize the apostrophe as an indicator that what follows is text and will show only 5E152. Without the apostrophe. It's much faster than changing the properties of a cell.
But you knew that, didn't you?
And, the point of my squawking is, aside from the fact that your user id alone makes me want to poke my coworkers' eyes out, you should explain the fix because some people like to know the "why's", rather than just the "how's".
01 Mar 07
Originally posted by SJ247Why?
I know that the use of an apostrophe, in a field formatted for numbers, does not change the formatting for that field to text.
And, the point of my squawking is, aside from the fact that your user id alone makes me want to poke my coworkers' eyes out, you should explain the fix because some people like to know the "why's", rather than just the "how's".
01 Mar 07
Originally posted by darvlayThanks for that, I independently figured putting a dash between the 5 and E does the same thing but the problem there is apostophe or dash, the part number might get misread by people downwind from me who wouldn't know what I typed, you the kind I mean, the beauracrat types that freak out when confronted with something so complex🙂 OK Martha, what does he mean 5 DASH E 152, I don't see that in our catalog, lets trash this order and go on to one we understand. But just hitting text in the format list for that one column took care of the problem so I just enter 5E152 without anyone freaking out.
Anyone who actually uses Excel knows that. SJ just has a hard-on for you.
In fact, if sonhouse didn't know the apostorphe function in the first place, he is MUCH better off now. But I wouldn't hold your breath waiting for a thank you.