| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
convert weekday string to number
Is there an easy way to convert a string which is either "Monday" thru
"Sunday" into a number to work with? In particular, I want to add a 1 if the cell contains "Monday", 2 if "Tuesday" etc. Any ideas? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to COnvert text string to number | Excel Discussion (Misc queries) | |||
| convert number to time format? | Excel Discussion (Misc queries) | |||
| Excell deletes 0 when its the first number in a string | Excel Discussion (Misc queries) | |||
| how can i convert a number in words? | Excel Discussion (Misc queries) | |||
| count number of occurences within a string | Excel Worksheet Functions | |||
Threaded Mode
