Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sorting numbers
I receive price updates from me vendors as an email attachment. At times I
need to retype the product codes because I am unable to sort or perform a Vlookup. I can even type the same number over the number I was emailed in the same cell and the number will become usable. All numbers show up as general when I check the format. Can any one help me? Jeff -- Excel is my work in progress |
#2
|
|||
|
|||
Good evening JTH Need a bit more info. If you select one of the numbers, before it's retyped in identically, does the number show up in the formula bar preceded by a '? DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=470055 |
#3
|
|||
|
|||
No there is not an "a" in front of the number in the formula bar.
Thank you for helping dominicb. -- Access is my work in progress "dominicb" wrote: Good evening JTH Need a bit more info. If you select one of the numbers, before it's retyped in identically, does the number show up in the formula bar preceded by a '? DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=470055 |
#4
|
|||
|
|||
Dominic was not asking with there was a letter 'a' in front of
the text in the formula bar. If you read his post closely, he is asking whether there is an apostrophe (') in front of the text in the formula bar. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "JTH" wrote in message ... No there is not an "a" in front of the number in the formula bar. Thank you for helping dominicb. -- Access is my work in progress "dominicb" wrote: Good evening JTH Need a bit more info. If you select one of the numbers, before it's retyped in identically, does the number show up in the formula bar preceded by a '? DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=470055 |
#5
|
|||
|
|||
I get it now. No there is not an apostrophe ( ' ) in front of the number. I
have used an apostrophe when entering numbers that could be dates. Thank you Chip, I will look a bit closer next time. -- Access is my work in progress "Chip Pearson" wrote: Dominic was not asking with there was a letter 'a' in front of the text in the formula bar. If you read his post closely, he is asking whether there is an apostrophe (') in front of the text in the formula bar. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "JTH" wrote in message ... No there is not an "a" in front of the number in the formula bar. Thank you for helping dominicb. -- Access is my work in progress "dominicb" wrote: Good evening JTH Need a bit more info. If you select one of the numbers, before it's retyped in identically, does the number show up in the formula bar preceded by a '? DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=470055 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting Numbers with Multiple Decimals (cont.) | Excel Discussion (Misc queries) | |||
Sorting numbers and text separately | Excel Discussion (Misc queries) | |||
Sorting alphanumeric numbers | Excel Discussion (Misc queries) | |||
Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
Sorting imported "numbers" | Excel Discussion (Misc queries) |