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.
|