Home
%3CLINGO-SUB%20id%3D%22lingo-sub-252883%22%20slang%3D%22en-US%22%3EExcel%20Table%20Talk%20Episode%207%3A%20New%20Data%20Types%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-252883%22%20slang%3D%22en-US%22%3E%3CP%3E%3C%2FP%3E%3CDIV%20class%3D%22video-embed-center%20video-embed%22%3E%3CIFRAME%20class%3D%22embedly-embed%22%20src%3D%22https%3A%2F%2Fcdn.embedly.com%2Fwidgets%2Fmedia.html%3Fsrc%3Dhttps%253A%252F%252Fwww.youtube.com%252Fembed%252FgbImc7A8_Q8%253Ffeature%253Doembed%26amp%3Burl%3Dhttp%253A%252F%252Fwww.youtube.com%252Fwatch%253Fv%253DgbImc7A8_Q8%26amp%3Bimage%3Dhttps%253A%252F%252Fi.ytimg.com%252Fvi%252FgbImc7A8_Q8%252Fhqdefault.jpg%26amp%3Bkey%3Dfad07bfa4bd747d3bdea27e17b533c0e%26amp%3Btype%3Dtext%252Fhtml%26amp%3Bschema%3Dyoutube%22%20width%3D%22600%22%20height%3D%22337%22%20scrolling%3D%22no%22%20frameborder%3D%220%22%20allow%3D%22autoplay%3B%20fullscreen%22%20allowfullscreen%3D%22true%22%20title%3D%22Video%22%3E%3C%2FIFRAME%3E%3C%2FDIV%3E%3CP%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3ELearn%20about%20the%20Stock%20Quote%20and%20Geographic%20data%20types%20in%20Excel.%20More%20information%20at%20%3C%2FSPAN%3E%3CA%20class%3D%22yt-simple-endpoint%20style-scope%20yt-formatted-string%22%20spellcheck%3D%22false%22%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fredirect%3Fv%3DgbImc7A8_Q8%26amp%3Bredir_token%3DJPLzgo3vpRSUSRB0zt83R53ZQ_R8MTUzNzAzNzQwNUAxNTM2OTUxMDA1%26amp%3Bevent%3Dvideo_description%26amp%3Bq%3Dhttp%253A%252F%252Fmsft.social%252F9zIXFs%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fmsft.social%2F9zIXFs%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-252883%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F49823i0718BBF2835CEE49%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22excel.PNG%22%20title%3D%22excel.PNG%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EJohn%20sits%20with%20me%20to%20explain%20rich%20data%20types%20-%20video%20embedded%20in%20the%20post.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EJohn%20sits%20with%20me%20to%20walk%20us%20through%20some%20of%20the%20latest%20and%20greatest%20features%20in%20Exce%3CEM%3E%3CBR%20%2F%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-252883%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBlog%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EData%20Insights%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-277002%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Table%20Talk%20Episode%207%3A%20New%20Data%20Types%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-277002%22%20slang%3D%22en-US%22%3E%3CP%3ECould%20be%20used%20with%20personal%20databases%20like%20employees%2C%20suppliers%2C%20goods%2C%20etc.%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-266788%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Table%20Talk%20Episode%207%3A%20New%20Data%20Types%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-266788%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20Geographical%20data%20type%20is%20very%20cool.%20What%20about%20a%20data%20type%20similar%20but%20with%20user%20defined%20metadata%20for%20x%20and%20y%20coordinates%20over%20a%20jpeg%3F%20Maybe%20a%20map%20of%20a%20building%20if%20the%20user%20wanted%20to%20highlight%20specific%20areas%20applicable%20to%20their%20desired%20needs.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-258975%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Table%20Talk%20Episode%207%3A%20New%20Data%20Types%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-258975%22%20slang%3D%22en-US%22%3E%3CP%3EWhy%20I%20can%20not%20use%20the%203%20letter%20word%26nbsp%3B%20TEN%2CSEN%2CVEN%2CBEN%20in%20a%20cell%20by%20it%20self%2C%20also%20in%20()%2C%7B%7D%2C%22%22%2C%5B%5D%2Cetc...%2C%20EXCEL%20changes%20it%20to%20TEM%2CSEM%2CVEM%2CBEM.%20Thank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-253962%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Table%20Talk%20Episode%207%3A%20New%20Data%20Types%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-253962%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20Stock%20Data%20type%20is%20great%20and%20have%20been%20using%20it%20extensively%20over%20a%20few%20hundred%20stocks.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20it%20stopped%20updating%20new%20data%20since%20yesterday.%20Could%20assist.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%2C%2C%2C%20Pete%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-449556%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Table%20Talk%20Episode%207%3A%20New%20Data%20Types%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-449556%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%20Need%20the%20community%20of%20experts%20to%20help%20me%20on%20this.%20I%20have%20a%20tabulations%20of%20three%20digit%20cell%20content%20from%200%20to%209%20in%20any%20order.%20Cell%20datus%20content%20on%2031%20rows%20up%20to%20columns%20ff%2C%20a%20lot%20to%20look%20up.%20Help%20me%20on%20this.%20Need%20to%20color%20cells%20which%20satisfy%20command%20criteria...Example..need%20to%20look%20up%20cells%20containing%20059%20in%20any%20order.%20Note%20cell%20may%20contain%20same%20digit%20or%20double%20digits%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-449558%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Table%20Talk%20Episode%207%3A%20New%20Data%20Types%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-449558%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F298176%22%20target%3D%22_blank%22%3E%40oghing%3C%2FA%3E%26nbsp%3B%2C%20that's%20a%20separate%20question.%20Please%20start%20new%20conversation%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2Fbd-p%2FExcelGeneral%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2Fbd-p%2FExcelGeneral%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Microsoft

 

Learn about the Stock Quote and Geographic data types in Excel. More information at http://msft.social/9zIXFs

6 Comments
Frequent Visitor

The Stock Data type is great and have been using it extensively over a few hundred stocks.

 

However, it stopped updating new data since yesterday. Could assist.

 

Many thanks.

 

Cheers,,, Pete

Occasional Visitor

Why I can not use the 3 letter word  TEN,SEN,VEN,BEN in a cell by it self, also in (),{},"",[],etc..., EXCEL changes it to TEM,SEM,VEM,BEM. Thank you.

Occasional Visitor

The Geographical data type is very cool. What about a data type similar but with user defined metadata for x and y coordinates over a jpeg? Maybe a map of a building if the user wanted to highlight specific areas applicable to their desired needs.

Occasional Visitor

Could be used with personal databases like employees, suppliers, goods, etc. ?

New Contributor

Hello! Need the community of experts to help me on this. I have a tabulations of three digit cell content from 0 to 9 in any order. Cell datus content on 31 rows up to columns ff, a lot to look up. Help me on this. Need to color cells which satisfy command criteria...Example..need to look up cells containing 059 in any order. Note cell may contain same digit or double digits

 

 

 

Hi @oghing , that's a separate question. Please start new conversation here https://techcommunity.microsoft.com/t5/Excel/bd-p/ExcelGeneral