Weird Excel issue

  pcolvin00 10:33 25 Mar 10

Ok. This is weird.... Either that or logical for a Greek... (Literally)

Open Excel 2007, Format a cell using Special, change where it says general to "00000000" (eight zeroes no quotes) enter some numbers, so that when upto 8 numbers are entered it preceeds the rest with zeroes upto eight characters... then go back into Cell formatting and it has changed to Special > Greek Locale and some writing I can't understand....

What's going on? Or is this normal?

  scotty 11:15 25 Mar 10

I see what you mean (am using 2003 version).

000 gives you Chinese (Taiwan)
0000 - Portugese
00000 - English (US)
000000 - Chinese (PRC)

Don't know what is going on but it does still appear to give you the correct format.

  VoG II 11:29 25 Mar 10

Instead of Special use Custom, although this also sets Special to Greek Locale.

  pcolvin00 12:42 25 Mar 10

"Instead of Special use Custom, although this also sets Special to Greek Locale."

Tried that... Anyone know why this is happening? Or any ideas?

For now the formula is working so things are ok but just wondering what's going on in the minds of MS Excel techies....

This thread is now locked and can not be replied to.

Sony Xperia XZ Premium review: Hands-on with the new 4K HDR phone with Motion Eye camera and Snapdr5…

1995-2015: How technology has changed the world in 20 years

Best laptop for design and art 2017: we test Apple, Dell, HP, Lenovo and Microsoft's best models…

CarPlay tips & troubleshooting guide: CarPlay tips & troubleshooting guide: Get the most from…