removing data from Excel file

Search for [*] and replace with nothing.

when i try the find and replace it comes back with a weird formatting, i would love to just take the phone numbers?

Change the format of the column to number.

@pkwan, once the value have been turned into numbers, no formatting will turn them into text. Text is a data type. A number is a data type. You cannot change a data type by formatting.

ok i think i have done most of that, its now adding .00 to the end can i remove all of them? without deleting other 0 that might appear?

found it!!

Hi Guys, it wont preserve the number when i save it as a CSV ?

The format is preserved in the csv file (open it in notepad and see for yourself). When opening in Excel it uses the default format (General) unless you explicitly give it a different format (number).

ah ok, so we are using this as a batch sms it should be ok??

As long as the file is not being open by Excel you're good to go.