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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i get formula to recognise text as = to a number?(excel)
to convert test to numbers use the =text()
if cell A1 contains in numbers $123.00 the in A2 you could put ="The total for January = "&TEXT(A1,"$00.00") "david" wrote: 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i get formula to recognise text as = to a number?(excel)
david
One method is a formula. Adjust to suit. =LOOKUP(B1,{"A","B","C","D"},{1,2,3,4}) Gord Dibben MS Excel MVP On Thu, 8 Mar 2007 21:43:10 -0800, david wrote: 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? |
Reply |
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) |