![]() ![]() ![]() There is nothing wrong with the form of the numeric text in particular, the dollar signs ("$") do not cause any problems. Note: Before making the changes below, make a copy of the Excel file, just in case you make a mistake and need to revert to the original file. The following is a list of some free file-sharing Redact any private identifying information. If that does not work, it would help us help you if you uploaded an example Excel file to a file-sharing website and post the public/share URL in a response here. In either case, choose an appropriate numeric format (General or otherwise) for the resulting numeric column (B2:B100 or modified A2:A100). If you wish, you can copy B2:B100 and paste-value into A2:A100 in order to replace the original data. If the data is in A2:A100, enter the following into B2 and copy down through B100: ![]() In that case, and if you cannot return to the original data, you will need to do the following. Set a single columnal range of data (one at a time, if more than one), then click Data, Text To Columns, Finish.Ĭaveat: Some data might still not be convert(ible) because they contain nonbreaking spaces. Then try using Text To Column to convert the numeric text to actual numbers. If you can go back to the original data, that would be best. It prevents any possibility of coercing Excel to recognize the data as numbers, especially the recommendation to use =A2*1. Huh?! You changed normal spaces t o nonbreaking spaces?! I’ve replaced spaces using the number pad to ASCII 160 non-breaking. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |