![]() The formula is cell D2 refers to cells B2 and B3 and returns the correct result, which is 50. Numerical values are always aligned on the right when using the "General" number format. ![]() When you copy or import data from other applications the numbers are often inserted as text.Īll the values in column B are being treated as text. If you want to have a currency symbol appear before a numerical value then you need to apply the relevant number format. ![]() To avoid any unpredictable results in your formulas never manually change the alignment, this way you can easily spot any numerical values that are being interpreted as text. If the alignment is not changed, then only numbers aligned on the right will be used in numerical calculations. (Tools > Options)(Error Checking tab, "Number stored as text")Įxcel will frag any cells that contain numbers that are formatted as textĪ green flag will be displayed in the top left corner click menu button and select "Convert to Number"ġ) Multiple the values by 1 using Paste Special This often happens when you import data from Access It is not possible to perform calculations on any numbers that are being interpreted (or formatted) as text If numbers are left aligned then they are probably being interpreted as text. Sometimes numbers can look like numbers when they are infact text.Īll numbers should be right aligned by default
0 Comments
Leave a Reply. |