Hello,
Can anyone please tell me how to add all the data in a spreadsheet in quotation.
For example if I have number 12345 in a cell I would like to be able to add that number in double quotation. Like this "12345".
I tried the following formula
=Char(34) & A1 & Char(34)
But keep on getting error #NAME?
I don't want to use the custom format, because I would have to use two diffrent format for the decimal number...
I want to use a formula.
Does anyone know how to do this..
Thanks
Can anyone please tell me how to add all the data in a spreadsheet in quotation.
For example if I have number 12345 in a cell I would like to be able to add that number in double quotation. Like this "12345".
I tried the following formula
=Char(34) & A1 & Char(34)
But keep on getting error #NAME?
I don't want to use the custom format, because I would have to use two diffrent format for the decimal number...
I want to use a formula.
Does anyone know how to do this..
Thanks