How to remove Apostrophe in excel
Closed
layhui
Posts
1
Registration date
Thursday September 24, 2015
Status
Member
Last seen
September 24, 2015
-
Sep 24, 2015 at 10:16 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Sep 25, 2015 at 08:28 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Sep 25, 2015 at 08:28 AM
Related:
- How to remove Apostrophe in excel
- How to add apostrophe over e - Guide
- How to take screenshot in excel - Guide
- How to remove recent files in windows 11 - Guide
- Number to words in excel - Guide
- How to remove guest mode in chrome - Guide
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Sep 25, 2015 at 08:28 AM
Sep 25, 2015 at 08:28 AM
layhui, Good morning.
After you remove dash from that cell, probably all the content was left-aligned.
I suppose the signal apostrophe stays in a content.
When this happen, a RED triangle appears at left indicating that there is a error at this cell.
If you click on it, will appears a message that there is a NUMBER with text format at that cell.
Appears a option to "Convert this to number".
Try to choose this one.
If after it a number is converted to Scientific format don't worry about it.
Format Menu and choose NUMBER.
Please tell us if it worked for you.
After you remove dash from that cell, probably all the content was left-aligned.
I suppose the signal apostrophe stays in a content.
When this happen, a RED triangle appears at left indicating that there is a error at this cell.
If you click on it, will appears a message that there is a NUMBER with text format at that cell.
Appears a option to "Convert this to number".
Try to choose this one.
If after it a number is converted to Scientific format don't worry about it.
Format Menu and choose NUMBER.
Please tell us if it worked for you.
