Formatting a cell w/"@"

[Brad E]

A Custom format of ["HI "@] and an entry of "BRAD" in the
cell will output "HI BRAD".
Also a Custom format of [00] (zero zero) with an entry
of "5" will output "05".

Could I do a combo of these for a two digit year, so an
entry of 5 for 2005 would output "YEAR=05"?

TIA, Brad E.

 

[Debra Dalgleish]

Use the custom format: "YEAR="00

A Custom format of ["HI "@] and an entry of "BRAD" in the
cell will output "HI BRAD".
Also a Custom format of [00] (zero zero) with an entry
of "5" will output "05".

Could I do a combo of these for a two digit year, so an
entry of 5 for 2005 would output "YEAR=05"?

TIA, Brad E.

 

[Guest]

Format cells > Custom > "Year = " 00

Cheers
Juan