diTii.com Digital News Hub

Sign up with your email address to be the first to know about latest news and more.

I agree to have my personal information transfered to MailChimp (more information)


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:

  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!


Share This Story, Choose Your Platform!

Get Latest News

Subscribe to Digital News Hub

Get our daily newsletter about the latest news in the industry.
First Name
Last Name
Email address
Secure and Spam free...