Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i get formula to recognise text as = to a number?(excel)
i am wring aon a scheduling spreadsheet i am tryo to find a way so that i
can enter a character in cells in one part in the preadsheet to stand for shifts and so that i can have tha chaacter stand for a number so that i can use it to come up with a total .( the bottom is divided into 1/2 hrs and used to determine the shift, the top is also in 1/2 hs but is based on the salesfor that day) is there a way i camn do this so that it will be easy to for others to use? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why does excel not recognise row 1 as a header row when sorting? | Excel Discussion (Misc queries) | |||
How to get an Excel function to recognise text | Excel Discussion (Misc queries) | |||
How can i split combined number and text in excel using formula? | Excel Worksheet Functions | |||
why won't excel recognise times | Setting up and Configuration of Excel | |||
How do I get Excell to recognise 0 at the beginning of a number? | Excel Discussion (Misc queries) |