If the numbers are really text, you can remove the commas by selecting your range of data, going to the standard toolbar and hitting Edit -> Replace (Ctrl+H).
On the Replace tab, enter a comma in the "Find What" option. Leave the "Replace with" option blank.
or Format as General, Number (without thousands separator), or Custom as 0.00
Post a Comment
Please write here your valuable comment.