View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kardock Kardock is offline
external usenet poster
 
Posts: 3
Default formatting text in a cell

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!