Text Prefix?

[ais4apple]

Hi

I was wondering whether it is possible to format a group of cells so that all numbers entered appear with a text prefix?

For example: I have a column of non-consequtive numbers, all of which I want to appear with the prefix VOLUME.

I have tried using formating the cells by going into custom but I get an error message say that Excel can not use the number format I have typed?

Any help would be greatly appreciated

Cheers
A very tired excel novice

 

[barry houdini]

depending on the format of your numbers you could use a custom number format like

"volume" 0

 

[Scott Huish]

or if you want the General format with those words in front:

"VOLUME "General

 

[ais4apple]

Thanks Barry - I was missing the quotation marks.

Cheers

 

[ais4apple]

Thanks as well Hotpepper

I know its probably a very basic question to you guys but I did a search and couldn't come up with anything.

Much appreciated