Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello All
I am trying to format a set of cells, A1:A4 that have the following values. A1=1; A2=2; A3=3; A4=4 I however want the displayed information to show up as "Very Low", "Low", "High" and "Very High" If I just type the text in, I cannot find a way to sort them in the numerical order I like because it sorts alphabetically, so I have to put them in as numbers to get the sort working. Is there anyway I can have them display as text or can I leave them as text and build a custom sort list so that they will sort in the order as above. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Display the number in the Indian format | Excel Discussion (Misc queries) | |||
To display number in text format in cells | New Users to Excel | |||
Custom number display format | Excel Worksheet Functions | |||
Format number to display % symbol smaller than onther text in cell | Excel Discussion (Misc queries) | |||
Number format need to display 0001 etc | Excel Discussion (Misc queries) |