Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
This is my formula: =LEFT(A8,3)
A8 = "00500" A8 is formatted as text. Per the functions argument, the reult should be "005". Instead, the formula is displayed instead of the result. Why is this not displayed and how can I correct? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
The cell was formatted as text when you entered the formula.
Format as General AND re-enter the formula (F2, ENTER) -- Kind regards, Niek Otten Microsoft MVP - Excel "evoxfan" wrote in message ... This is my formula: =LEFT(A8,3) A8 = "00500" A8 is formatted as text. Per the functions argument, the reult should be "005". Instead, the formula is displayed instead of the result. Why is this not displayed and how can I correct? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Change the format in the cell with the formula to general
-- Regards, Peo Sjoblom "evoxfan" wrote in message ... This is my formula: =LEFT(A8,3) A8 = "00500" A8 is formatted as text. Per the functions argument, the reult should be "005". Instead, the formula is displayed instead of the result. Why is this not displayed and how can I correct? |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
yes, Excel says the argument is text but what it means is that it treat the argument as text, not that the function should be entered into a cell formatted as text. The LEFT, RIGHT and MID function return text, which means if you have a formula such as =LEFT(A1,2) and A1 contains a number 12345 Excel returns the text 12, the result is text not a number. But you can easily convert it back to a number if need be. -- Thanks, Shane Devenshire "evoxfan" wrote: This is my formula: =LEFT(A8,3) A8 = "00500" A8 is formatted as text. Per the functions argument, the reult should be "005". Instead, the formula is displayed instead of the result. Why is this not displayed and how can I correct? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formulas Are Displayed and are not calculating | Excel Discussion (Misc queries) | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
CountIf formula results in the formula itself being displayed. | Excel Worksheet Functions | |||
Calculating Cells n% displayed in a cell? | Excel Worksheet Functions | |||
formula is displayed as literal text instead of formula result | Excel Discussion (Misc queries) |