how to create a custom YEAR format in Excel

[maximrealG]

There is a task: numbers are given that are equal to the time of work in the company, you need to add the word years to these numbers using a custom format so that these numbers and the inscription years are displayed

 

[etaf]

is this a homework assignment question
happy to help - but NOT provide the answer directly
what have you tried so far and what results have you had

 

[maximrealG]

is this a homework assignment question
happy to help - but NOT provide the answer directly
what have you tried so far and what results have you had

I tried adding the following formulas: 0 "year" , # "year" , year

 

[etaf]

i assume you mean customer formats and not formulas in the cell
that should work
# "year"
or to display a 0
#0 "Year"

 

[maximrealG]

i assume you mean customer formats and not formulas in the cell
that should work
# "year"
or to display a 0
#0 "Year"

0 years is written instead of the required number

 

[etaf]

not following
can you post a sample
you can see the image i posted

[=1]0" year";0" years"
will show 0 years , and 1 will show year

 

[maximrealG]

not following
can you post a sample
you can see the image i posted

[=1]0" year";0" years"
will show 0 years , and 1 will show year

thank you so much mate, you help me solve

 

[etaf]

you are welcome