hi
this may work.....assumeing that excel sees the data as text.
=REPLACE(B3,3,1,"")
assuming your data in column B.
add a column next to the data. copy the formula down as far as needed. the
copy the new column and paste special values. delete(or archive) old data.
if excel is not seeing the data as text you may be able to just refomat.
Post back if problems.
regards
FSt1

"JohnBlack" wrote:

Dear all, I'm having a little trouble with an excel sheet. It consist of 500
plus records with values in it. Because the author of the document it was
copied from made some error with placing the decimals I'm now stuck with some
cells where there are multiple comma's such as:

78,583,506199
84,831,029277
87,756,172853
10,758,322459

I'm looking for a way to remove the first comma. Find and replace obviously
doesn't work because that will replace all the commas . Does anyone know of a
way to only remove the first comma ?