Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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! -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200910/1 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Regional Settings with Date | Excel Discussion (Misc queries) | |||
regional settings | Excel Worksheet Functions | |||
Regional settings independent list separator in arrays | Excel Worksheet Functions | |||
Problems with Turkish regional settings | Excel Discussion (Misc queries) | |||
Regional Settings | Excel Discussion (Misc queries) |