Plus sign bug on excel online

%3CLINGO-SUB%20id%3D%22lingo-sub-1538950%22%20slang%3D%22en-US%22%3EPlus%20sign%20bug%20on%20excel%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1538950%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%20could%20use%20some%20help%20please.%20All%20of%20a%20sudden%20the%20%2B%20sign%20which%20i%20use%20to%20start%20formulas%20only%20works%20if%20i%20stick%20within%20the%20cell.%20e.g.%20%2B5*5%20calculates%20to%2025%20in%20the%20same%20cell%2C%20but%20once%20I%20point%20to%20different%20cell%20e.g.%20%2B%20cell%20E2%2C%20it%20doesnt%20point%20to%20that%20cell%20it%20just%20shows%20a%20plus%20sign%20in%20the%20cell%20as%20if%20the%20cell%20is%20in%20text%20format%20when%20it%20its%20not.%20The%20%3D%20sign%20allows%20me%20to%20point%20to%20another%20cell%20but%20the%20%2B%20sign%20only%20allows%20formulas%20within%20the%20cell%20not%20involving%20any%20other%20cells.%20This%20just%20happened%20a%20couple%20of%20hours%20ago.%20Is%20it%20just%20me%20or%20are%20all%20users%20experiencing%20this%3F%20Any%20solutions%20welcom%20thanks.%20I%20know%20I%20can%20still%20use%20%3D%20sign%20but%20just%20do%20alot%20of%20work%20on%20excel%20and%20used%20to%20%2B%20sign%20to%20start%20formula.%20Thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1538950%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1539201%22%20slang%3D%22en-US%22%3ERe%3A%20Plus%20sign%20bug%20on%20excel%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1539201%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F736706%22%20target%3D%22_blank%22%3E%40John112210%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENever%20tried%20it%20before%20in%20Excel%20Online.%20Checked%20right%20now%20-%20yes%2C%20the%20same%20behaviour.%20Don't%20know%20how%20to%20change%20it%20if%20possible.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1539596%22%20slang%3D%22en-US%22%3ERe%3A%20Plus%20sign%20bug%20on%20excel%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1539596%22%20slang%3D%22en-US%22%3EThanks%20Sergei.%20Was%20working%20fine%2C%20I%20must%20have%20pressed%20something%20as%20changed.%20Quite%20annoying%20as%20use%20the%20number%20pad%20a%20lot%20so%20easier%20to%20use%20plus%20sign.%3C%2FLINGO-BODY%3E
Deleted
Not applicable

Hi there, could use some help please. All of a sudden the + sign which i use to start formulas only works if i stick within the cell. e.g. +5*5 calculates to 25 in the same cell, but once I point to different cell e.g. + cell E2, it doesnt point to that cell it just shows a plus sign in the cell as if the cell is in text format when it its not. The = sign allows me to point to another cell but the + sign only allows formulas within the cell not involving any other cells. This just happened a couple of hours ago. Is it just me or are all users experiencing this? Any solutions welcom thanks. I know I can still use = sign but just do alot of work on excel and used to + sign to start formula. Thanks.

2 Replies

@Deleted 

Never tried it before in Excel Online. Checked right now - yes, the same behaviour. Don't know how to change it if possible.

Thanks Sergei. Was working fine, I must have pressed something as changed. Quite annoying as use the number pad a lot so easier to use plus sign.