Formatting Text
 

I have a spread sheet that has a range of cells with text in them. I
would like to, using cell format, to change the cells from:

blah

to

/ blah

I have tried a number of different ways of typing this in using custom
formats, but none of them seem to work. I have tried:

"/ "General
"/ "# (only works on numerical values)
"/ "Text

Nothing seems to work. Does anyone know how to enter the format
properly, or is this impossible? Any help would be greatly
appreciated. Thank you.

Formatting Text
 

B1 ="/ "&A1

"mastermind" wrote:

I have a spread sheet that has a range of cells with text in them. I
would like to, using cell format, to change the cells from:

blah

to

/ blah

I have tried a number of different ways of typing this in using custom
formats, but none of them seem to work. I have tried:

"/ "General
"/ "# (only works on numerical values)
"/ "Text

Nothing seems to work. Does anyone know how to enter the format
properly, or is this impossible? Any help would be greatly
appreciated. Thank you.

Formatting Text
 

" / "@

"mastermind" wrote:

I have a spread sheet that has a range of cells with text in them. I
would like to, using cell format, to change the cells from:

blah

to

/ blah

I have tried a number of different ways of typing this in using custom
formats, but none of them seem to work. I have tried:

"/ "General
"/ "# (only works on numerical values)
"/ "Text

Nothing seems to work. Does anyone know how to enter the format
properly, or is this impossible? Any help would be greatly
appreciated. Thank you.