Loading suggested videos
Ctrl + Space to select the entire column containing the text-formatted numbers.Alt + A + E + F to quickly apply the Convert to Number function.Result: The values will now be recognized as numbers and aligned to the right, following Excel’s number formatting.
Tip: If the shortcut doesn’t work, try using Text to Columns or multiply the column by 1 using Paste Special.
Your feedback helps us improve our content.