[Excel] Jill Foster's Question
- Select the entire column of your data having this issue (apostrophe in front of numbers)
- You shall see a yellow box (with exclamation mark) as shown below
- Click the yellow box and select [Convert to Number]
- Done. Those data is converted from text to number (ie: apostrophe is removed)
Source: ---
Disclaimer: The information in this webpage is shared by anonymous users from external online sources. We cannot guarantee its accuracy or truthfulness. Users should exercise caution and verify information independently.