Quizzes & Puzzles0 min ago
Excel 2007
I have columns of figures where some cells display $ symbol to the left, separated from the amount, which is oriented to the right.
However, other cells show both $ and amount oriented to the right.
I want to set them all to appear as in the first example but cannot unlock the secret.
Any help would be appreciated.
However, other cells show both $ and amount oriented to the right.
I want to set them all to appear as in the first example but cannot unlock the secret.
Any help would be appreciated.
Answers
1 to 3 of 3
Best Answer
No best answer has yet been selected by oakville. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.
Are the cells in the same column?
Have you tried search and replace to remove the $ signs?
I'd do a search and replace to convert the cells to numbers only.
You'd need to check whether you want to get rid of $ or $+space or whatever.
Once the cells contain only numbers you can then apply appropriate formatting.
Have you tried search and replace to remove the $ signs?
I'd do a search and replace to convert the cells to numbers only.
You'd need to check whether you want to get rid of $ or $+space or whatever.
Once the cells contain only numbers you can then apply appropriate formatting.
1 to 3 of 3
