letters

%3CLINGO-SUB%20id%3D%22lingo-sub-1599392%22%20slang%3D%22en-US%22%3Eletters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1599392%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%20I%20put%20in%2012-24%20and%20I%20get%20dec%20how%20can%20I%20change%20this%20.%20I%20am%20new%20I%20just%20now%20joined%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1599392%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

  I put in 12-24 and I get dec how can I change this . I am new I just now joined

1 Reply
Highlighted

Hello @wndataylorksk

 

Are we talking about Excel here? If that is the case Excel does an automatic detection of the information and gives it a best effort to format it. In your case that would be the American date format.

If you want Excel to calculate you need to put in =12-24. If you want it to be a string there are two ways. One is to put quotes around your numbers "12-24" and the the second is to use the ribbon to format the cell as text before adding anything into it. 

I hope that helps.

Cheers
Rolf
#MCT #LearnWithRolf #TheCloud42