CODEWITHSUNDEEP
excelvbanumber-formatting
user1212275
user1212275

Reputation: 13

Forcing a Region Code format in Excel

I have the following problem, I have a number in one column formatted as 2.60 which is being converted to the format of 2,6 when the region code is changed to "German (Germany)" in Windows. I need this number to retain its original formatting, 2.60. Any help you can provide is greatly appreciated, I've searched all over and have come up with nothing.

Thanks!

Upvotes: 1

Views: 1438

Answers (2)

JMax
JMax

Reputation: 26601

You can choose a specific separator in Excel (if you don't want it to depends on Windows settings):

In Office 2007

  • open the Excel Options window
  • select "Extended" (Erweitert in a German version)
  • at the bottom of the first group, choose "Edit options" (Optionen bearbeiten)
  • there is a checkbox to override the default decimal separator

In Office 2003

  • go to Menu > Tools > Options
  • choose International
  • you can choose the Excel decimal separator

Upvotes: 2

Idan Arye
Idan Arye

Reputation: 12623

You need to change the cell's NumberFormat property to "0.00"

Upvotes: 0

Related Questions