=concatenate("""",A1,"""",",","""",B1,"""",",","""",C1,"""",), I get an error message "error 528'. I was told in a previous forum to use this formula in the first cell next to the numbers to be converted.

I have 1000 rows of 3 colums of numbers that have to read as follows:

"1","400100000311","52"

I can get it to a text format without quotes, but need the quotes as above.

I'm running windows 7, and open office.

Thanks for any help you can give me.