Conversion numbers in text format to number format.

Anonymous
2025-04-02T15:33:28+00:00

Hello to everybody. I need help to convert numbers under text format toward format numbers in excel. I have a MackBook Pro. I have attempt in several ways without succes. By the other hand, in the warning Icon ! does not appears the option "convert text into number".

Microsoft 365 and Office | Excel | Other | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
HansV 462.7K Reputation points MVP Volunteer Moderator
2025-04-02T19:00:04+00:00

Try the following:

  • Select numbers-as-text in a column.
  • Set the number format to General.
  • Press Control+H to activate the Replace dialog.
  • Click in the 'Find what' box.
  • Press Option+Space to enter a non-breaking space.
  • Leave the 'Replace with' box empty.
  • Click 'Replace All', then close the Replace dialog.
  • If the values are now right-aligned. you're probably done.
  • If not, activate the Data tab of the ribbon.
  • In the Data Tools group, click 'Text to Columns'.
  • Select Delimited, then click Finish.

Was this answer helpful?

0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-04-02T16:03:40+00:00

    I have tried after your suggestion without succes. Perhaps I have to follow step by step how to do. In case you have a link I will apreciate your help.

    Was this answer helpful?

    0 comments
  2. HansV 462.7K Reputation points MVP Volunteer Moderator
    2025-04-02T15:47:22+00:00

    Have you tried Data tab of the ribbon > Text to Columns?

    Was this answer helpful?

    0 comments