| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Divide by 3
Good to see, and thanks for the response. -- GARY Wrote: Hi Bryan, It works!!! I discovered my problem. Thread #5 contains: Bryan Hessey Wrote: try =IF(MID(A1,2,1)="$",LEFT(A1,1)&TEXT(MID(A1,3,FIND( " ",A1)-3)/3,"$#.00")&MID(A1,FIND(" ",A1),99),A1) When I copied that formula, I inadvertantly included the on the second line so, when I pasted it into my spreadsheet, that section of the formula looked like this: FIND(" ",A1)-3)/3e Deleting the resolved my problem. Thank you muchly for you help! gary -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=540474 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you divide two cells in a pivot table to equal a %? | Excel Worksheet Functions | |||
| how do I Divide "/" a row of cells by another row of cells? | Excel Worksheet Functions | |||
| Divide number and add remainder in another cell | Excel Discussion (Misc queries) | |||
| Custom Format to divide by 10 | Excel Discussion (Misc queries) | |||
| Divide one row over other row I dont wont to divide one number | Excel Discussion (Misc queries) | |||
Hybrid Mode
