Excel 2010: Tips to change Numeral shapes

This post tell us how to know the language of the numbers that you see in the cell of a Excel file that contains some numeral shapes:Select cell that contains number digit Click Home ribbon tab, and then click Number button. (Or you could press Ctrl+1). On “Format Cells” dialog, click Number Tab, then Custom in Category list. You’ll notice that selecting format has some […]

This post tell us how to know the language of the numbers that you see in the cell of a Excel file that contains some numeral shapes:

  1. Select cell that contains number digit
  2. Click Home ribbon tab, and then click Number button. (Or you could press Ctrl+1).
  3. On “Format Cells” dialog, click Number Tab, then Custom in Category list. You’ll notice that selecting format has some kind of code starting with [$- and before closing square bracket, last 4 digits’re Hexadecimal value which represents Locale language ID.
  4. Then use Hexadecimal to look up language in Locale ID (LCID) Chart. To make finding hexadecimal easier – when LCID chart appears – just hit CTL-F (to find) and then type that number in the Find box and it’ll go right to the language that’s associated with!
    As shown in the pic, the 041E is telling us that the numeral shape is a Thai number!

[Source]

About The Author

Deepak Gupta is a IT & Web Consultant. He is the founder and CEO of diTii.com & DIT Technologies, where he's engaged in providing Technology Consultancy, Design and Development of Desktop, Web and Mobile applications using various tools and softwares. Sign-up for the Email for daily updates. Google+ Profile.