Share via

Problem on Excell with numbers stored on cells

Luis Montano 1 Reputation point
2022-04-04T17:13:23.977+00:00

I have a problem, lets suppose that I have the following content in a excel cell
189857-image.png

If I try to insert a space in the cell, the formula bar show text different than real cell
189858-image.png
189845-image.png

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,689 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emily Hua-MSFT 27,601 Reputation points
    2022-04-05T03:07:56.947+00:00

    Hi @Luis Montano

    Welcome to Q&A forum.

    Could you tell us which version of Office are you using now?
    On my environments, one with Microsoft 365 Apps intalled, one has Office 2016, I can not reproduce your issue both on them.

    > If I try to insert a space in the cell, the formula bar show text different than real cell

    Do you double-click or press F2 on D14 and D15 to go to edit mode, then insert the spaces in cells?
    If you insert the space in formula bar after you locate to D14 or D15 directly, does this issue occur?

    Please choose D14, right click on it, check whether its format is "Text".
    Please also check the cell format for D15, make sure it is "General" or "Number".

    Besides, it's recommended to run Excel in safe mode to have a check. Safe Mode can help us rule out add-ons and macros
    You can hold on Ctrl key, click or doubel-click Excel icon, until Excel asks you "do you want to start Excel in safe mode", then please release Ctrl key and click "Yes".
    I suggest you create a new blank workbook to have a check.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.