Can you have auto updating AND manually typed permanent text in one cell?

I need it to be like:

=B10 2014

(So the first part changes depending on what B10 is but the 2014 always stays)?

Or is that not possible? Thanks.

You can use a custom format to do this.

the custom format would be something like:
0" 2014"

Originally Posted by ragulduy

You can use a custom format to do this.

the custom format would be something like:
0" 2014"

It didn't work. Thanks anyway!

Hi

Please see attachment for an example.

Originally Posted by ragulduy

Hi

Please see attachment for an example.

Thanks but the cell i'm using to input before "2014" is text, not a number. What do i use instead of 0"?

okay, i found out it's
@" 2014"

However, when i type "=B10", it displays the cell as "=B10 2014" ?

use @ instead of 0

Originally Posted by ragulduy

use @ instead of 0

thanks!

I need a modification of this I need custom format as if I enter 1 in cell it should have Excellent as cell value, if I enter 2 it should automatically change as good etc.
thank you very much in advance

don't use the quotes around =B10