Format Changing In Numbers

You can try the following script below:

1. Copy-paste into Script Editor (in Applications > Utilities)
2. The first time make sure Script Editor is listed and checked at System Preferences > Security & Privacy > Privacy > Accessibility.
3. With your machine and Numbers document still set to Romania region select the cells in a copy of the imported table (that have the yyyy.mm.dd date format and 0.000 US formatting for numbers).
4. Click the <run> button in Script Editor.

If the script does not do what you want, perhaps you can describe the problem and I can try to adapt it.

If it does do what you want and you expect to use it frequently then you can place it in the Script Menu for easy access with one click.

No AppleScript knowledge is needed to use the script, and it should take about a minute to try it out.

SG

The script:

tell front document of application "Numbers"
	tell active sheet
		tell (first table whose class of selection range is range)
			repeat with c in cells of (get selection range)
				set v to formatted value of c as text
				if text 1 thru 2 of v is in {"19", "20"} then -- a date
					set value of c to (my replaceSubstr:"." withSubstr:"-" inString:v)
				else
					set value of c to (my replaceSubstr:"." withSubstr:"," inString:v)
				end if
			end repeat
		end tell
	end tell
end tell

to replaceSubstr:thisStr withSubstr:thatStr inString:aString
	set my text item delimiters to thisStr
	set textItems to text items of aString
	set my text item delimiters to thatStr
	set theText to textItems as text
end replaceSubstr:withSubstr:inString:

Would you be open to using a small AppleScript that would allow you to select cells and click a button to change the format so US date format is recognized as such by Numbers even when your regions is set to Romania?

If so please post a screenshot showing what a date when you've opened the file with your default region set to Romania. command-4, select area on screen, release, attach downloaded image from desktop to a new post here, using the 'mountains' icon below the message compose window.

Also an example of what a number looks like when you've opened the file with the default region set to Romania.

SG