formatting a cell

L

Lise

I've set up a timesheet for our office and was wondering
is there a way to reference:

In cell B5 to B7 I have a drop down list for IE $10, DC
$5, FU $5 in which they have to choose which $ amount. I
have it set up for 5 days a week and then say in cell c5 I
want it to add the totals but cannot set the formula
because there is Text infront of the $ amount. Is there a
way to calculate this?
 
A

Andy B

Hi

Set up your list without the dollar sign and format the cells as currency
instead.
 
D

Dave Peterson

I'm not Jason, but =mid() has 3 arguments.

The first is the string to search, the second is where to start, the last is for
how many characters.

The 255 in Jason's formula says to go 255 characters after you find the $ sign.
(Jason could have used a smaller number, but I bet 255 is pretty darn safe!)
 
Top