FORMATTING CURRENCY IN TWO DIFFERENT CELLS

%3CLINGO-SUB%20id%3D%22lingo-sub-1661146%22%20slang%3D%22en-US%22%3EFORMATTING%20CURRENCY%20IN%20TWO%20DIFFERENT%20CELLS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1661146%22%20slang%3D%22en-US%22%3E%3CP%3EIF%20YOU%20HAVE%20CELL%20A-1%20AND%20IT%20CONTAINS%20A%20CURRENCY%20NUMBER%20WITH%20A%20FIVE%20DIGIT%20FORMAT%20AND%20IN%20CELL%20C-4%20YOU%20HAVE%20THE%20FORMULA%20%3DA-1.%20WILL%20THAT%20FORMAT%20IN%20C-4%20DISPLAY%20THE%20SAME%20FIVE%20DIGIT%26nbsp%3B%20FORMAT%20THAT'S%20IN%20CELL%20A-1%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1661146%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1661458%22%20slang%3D%22en-US%22%3ERe%3A%20FORMATTING%20CURRENCY%20IN%20TWO%20DIFFERENT%20CELLS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1661458%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F791619%22%20target%3D%22_blank%22%3E%40Mike_Novak%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENot%20necessarily.%20Cell%20C4%20can%20have%20a%20different%20number%20format%20than%20cell%20A1.%3C%2FP%3E%0A%3CP%3EThe%20formula%20%3DA1%20only%20copies%20the%20value%20of%20cell%20A1%2C%20not%20its%20format.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

IF YOU HAVE CELL A-1 AND IT CONTAINS A CURRENCY NUMBER WITH A FIVE DIGIT FORMAT AND IN CELL C-4 YOU HAVE THE FORMULA =A-1. WILL THAT FORMAT IN C-4 DISPLAY THE SAME FIVE DIGIT  FORMAT THAT'S IN CELL A-1?

2 Replies
Highlighted

@Mike_Novak 

Not necessarily. Cell C4 can have a different number format than cell A1.

The formula =A1 only copies the value of cell A1, not its format.

Highlighted

@Mike_Novak 

If I understood your question correctly, the answer is Yes.

e.g. If you have a formula =A1 in the cell C4, the cell C4 will have the value of cell A1 and will inherit the number formatting of the referenced cell A1 as well.

 

Did you try it on your end? What did you get then?