Forum Discussion
Solved
"space" in number
Hello, How can i remove a space in a number that has been saved as a currency? EG: R1 200.00 I need the number to read as a Number, as in 1200, the space doesn't allow calculation columns or formu...
Select the range.
Press Ctrl+H to activate the Replace dialog.
Enter a space in the 'Find what' box and leave the 'Replace with' box empty.
Click 'Replace All'.
If that doesn't help. enter an R in the 'Find what' box and click 'Replace All' again.
CTRL+H "Find What:R" then press replace All.
Do the same for SPACE
Do the same for SPACE