Hi, I have received a file with a comma instead of a decimal point. How do i convert 4,56 to 4.56?
S Spannerman Apr 3, 2007 #1 Hi, I have received a file with a comma instead of a decimal point. How do i convert 4,56 to 4.56?
S Spannerman Apr 3, 2007 #3 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?
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?
B Bob Phillips Apr 3, 2007 #4 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)
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)
