Format cell to ...

%3CLINGO-SUB%20id%3D%22lingo-sub-1376344%22%20slang%3D%22en-US%22%3EFormat%20cell%20to%20...%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1376344%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20the%20year%20to%20appear%20in%20a%20cell%20and%20then%20a%20number%20with%204%20digits%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1376344%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1376383%22%20slang%3D%22en-US%22%3ERe%3A%20Format%20cell%20to%20...%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1376383%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F661779%22%20target%3D%22_blank%22%3E%40Pinto64%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20seems%20you%20want%20to%20put%20both%20number%20and%20alphabets%20in%20to%20the%20cell.%3C%2FP%3E%3CP%3EFollow%20this%3A%3C%2FP%3E%3CDIV%20class%3D%22co8aDb%20gsrt%22%3E%3CSTRONG%3ECombine%20Cells%20With%20Text%20and%20a%20Number%3C%2FSTRONG%3E%3C%2FDIV%3E%3CDIV%20class%3D%22RqBzHd%22%3E%3COL%20class%3D%22X5LH0c%22%3E%3CLI%3ESelect%20the%20cell%20in%20which%20you%20want%20the%20combined%20data.%3C%2FLI%3E%3CLI%3EType%20the%20formula%2C%20with%20text%20inside%20double%20quotes.%20For%20example%3A%20%3D%22Due%20in%20%22%20%26amp%3B%20A3%20%26amp%3B%20%22%20days%22%20NOTE%3A%20To%20separate%20the%20text%20strings%20from%20the%20numbers%2C%20end%20or%20begin%20the%20text%20string%20with%20a%20space.%3C%2FLI%3E%3CLI%3EPress%20Enter%20to%20complete%20the%20formula.%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20this%20helps!%3C%2FP%3E%3CP%3ERuskin%20%7C%20Admin%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.apps4rent.com%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.apps4rent.com%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.o365cloudexperts.com%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.o365cloudexperts.com%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I want the year to appear in a cell and then a number with 4 digits

1 Reply
Highlighted

@Pinto64 

It seems you want to put both number and alphabets in to the cell.

Follow this:

Combine Cells With Text and a Number
  1. Select the cell in which you want the combined data.
  2. Type the formula, with text inside double quotes. For example: ="Due in " & A3 & " days" NOTE: To separate the text strings from the numbers, end or begin the text string with a space.
  3. Press Enter to complete the formula.

 

I hope this helps!

Ruskin | Admin

https://www.apps4rent.com/

https://www.o365cloudexperts.com/