Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I convert a number in Excel such as 1001-1 to 1001-01?
I have several hundred numbers in my Excel file that need to be converted as
noted in the subject. The sorting is awkward in that 1001-11 sorts before 1001-2 and is obviously out of order- at least for my purposes. -- SgtBob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I SORT NUMBERS WITH TEXT EX 1000 1001 1000A | Excel Discussion (Misc queries) | |||
From 1001 to 1001-1 | Excel Worksheet Functions | |||
convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
Event 1001 & 1004 | Excel Discussion (Misc queries) |