Regional settings

  • Thread starter Ana via OfficeKB.com
  • Start date
A

Ana via OfficeKB.com

I have settings on my computer and my MS office that "," is for decimal
places and "." for thousands. In converted Excel file from some database I
have, and it is the other way arround: "." is for decimal places and "," for
thousands. So, in two excel files it's different, and in any way I change the
settings they are still different. And if I try to do find/replace in one
file, it's not wright becouse in that setting number like 10,000.00 is read
on my comuter like 10 and not like 10000 as it should be. This is a huge
problem for me and any help would be appriciated.., Thanks!
 
D

David Biddulph

The regional settings are controlled in Windows (through the Control Panel),
not in Excel.
If you are reading into Excel from another application, you need to ensure
that the Windows Regional Settings are appropriate for the data format that
you want to read.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top