Not even if you select them all then do it?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Spannerman" wrote in message
...
Thanks Amit,
This does not seem to work in excel when there are a large number of
prices.
There are some 8,000 prices where this change needs to occur.
Is a formula required?

"Amit GK" wrote:

Replace all (Ctrl+H) "," with "."

"Spannerman" wrote:

Hi, I have received a file with a comma instead of a decimal point. How
do i
convert 4,56 to 4.56?