Commas and periodes

[Øyvind Granberg]

Hi...

I want copy a lot of numbers from an english list into Excel.
Problem is that english uses . (periode) as a decimal divider, instead of a
, (comma) as we do here in Norway.

The thing is that Excel automatically change the properties of these cells
to DATE and 1.75 becomes jan.75
I want it to read 1,75 (with a comma) as a number and not a date.

Is there a solution to this?

PS: Forgive me if this message accures twice, My MS Live Mail software seems
not to have delivered the first one, so I try again

--


Zadig Galbaras
(nick)
www.tresfjording.com

 

[Rich Pasco]

In what format is your English list? If it's a plain text file (.TXT),
you could open it in a text editor (e.g. Notepad, built into Windows)
and replace all periods with commas, then save that result temporarily
and import it into Excel.

Alternately, you could temporarily change Windows' decimal divider at
Control Panel / Regional Options, re-start Excel and import your file,
save it, then change the decimal divider back.

- Rich

 

[Øyvind Granberg]

Hi Rich...

Thank you for your suggestions.
The latter is already utilized...

Darn those Americans for, in so many important areas, not complying with the
rest of the world.
Comma and not period as a decimal divider for one, and don't get me started
on their stupid measuring system which do not add up at all, and costs them
millions of dollars every year. Not to speak of lost missions to Mars.

I'm glad I am a Norwegian bloke, 'cause we're perfect i every way! ;-)
We're filthy rich.
We've got oil. We've got money in the bank.
Iceland is broke and we buy their bank cheap now.
We all got SUV's.
Gas is cheap, and our measuring system adds up.
We also eat whales.
A thousand years ago we ruled the world controlling areas like England and
Ireland.
Northern Europe, with Normandie.
We've run business in trade and warfare all the way from Scandinavia through
Novgorod to the Black Sea.
We discovered America four hundred years before Chr. Columbus did.
We run merchaneries missions in Istanbul.
The romans feared us!

Year after year Norway has topped UN's list over countries good to live in.
Michael Moore couldn't use reels from his visit to Norway in his last
documentary, because our way of living is so incredible to americans they
wouldn't believe him.

I wish for one thing; That I had the power to tell USA to comply, or we come
busting some heads again!

(this felt good to get out there, at four in the morning in Norway.

Goodnight!
Have a nice day.

 

[Gord Dibben]

A thousand years ago we ruled the world controlling areas like England and
Ireland.
Northern Europe, with Normandie.

And this is how you did it..................<g>

"Lutefisk is the Norwegians' attempt at conquering the world. When they
discovered that Viking raids didn't give world supremacy, they invented a
meal so terrifying, so cruel, that they could scare people to become one's
subordinates."

From an Interview with Jeffrey Steingarten, author of The Man Who Ate
Everything (translated quote from a 1999 article in Norwegian newspaper
Dagbladet


Gord Dibben MS Excel MVP

 

[Øyvind Granberg]

Hehe you're right... allmost... It's much worse

Lutefisk is not the worst meal the Norwegians have sprung upon the
world.
Lutefiks is fish soaked in a solution of caustic soda.

Gravlaks is much worse. Gravlaks is salmon soaked in spice and cognac for a
few days in a fridge.

But the worst is the hazardous Rakfisk.
Buried in the ground and left to partially rotten and then served as a meal.

Yeah, we Norwegians are really disgusting!!

--


Zadig Galbaras
(nick)
www.tresfjording.com

 

[Roger Govier]

Hi
Sounds interesting
Maybe we should all have a meeting in Norway to sample this fine food!!

 

[Øyvind Granberg]

YEah... great idea....
One way ticket...

--


Zadig Galbaras
(nick)
www.tresfjording.com