Do you mean you want to change the value within the cell? Or that you want a
formula in another cell that removes the dot? If the latter, try this
formula...

=--SUBSTITUTE(A26,".","")

To do the former will require VB code. If the former is what you want, then
when do you want it to happen... automatically when the number is entered
into the cell or do you want a macro in order to manually do multiple cells
all at once.

--
Rick (MVP - Excel)


"Kardock" wrote in message
...
hi all,

i need to change a value in a cell by removing a dot

for example, i need to convert 2.01 to 201

i can't find the correct formula to achieve my goal. i tried replace and
substitute but it ain't working.

can someone help?

thanks!