| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What a Relief
The Edit Replace = with = fixed this same problem for me also. Thanks so
much for the solution. IronMan "1stcoast" wrote: Thanks your solution fixed the problem also! "Ron Coderre" wrote: Try this: First, make sure B1 is not formatted as Text. Select B1, then FormatCellsNumber Tab (Category should NOT be Text) If the format is OK, then: Select B1 DataText-to-ColumnsClick the [Finish] button Does that fix the problem? Does that help? *********** Regards, Ron XL2002, WinXP-Pro "1stcoast" wrote: Cell A1 Formula in cell B1 00-1-36000-21800 SPPNT HUGGIES GOODNITES =LEFT(A2,16) The calculation returns the formula not a result. What am I doing wrong? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| My formula returns a result but the cell displays a zero? | Excel Worksheet Functions | |||
| Excel - return a picture or range rows as the result of a formula | Excel Worksheet Functions | |||
| Formula to return cell contents based on multiple conditions | Excel Worksheet Functions | |||
| Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
| Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
Threaded Mode
