View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Sloth Sloth is offline
external usenet poster
 
Posts: 252
Default decimal to comma

Use Edit-Replace to replace all decimals with nothing (leave replace blank)
and hit replace all. Then change the format to add the commas in.

"George P" wrote:

how do i convert a set of numbers represented in non-US format, n.nnn.nnn, to
US format n,nnn,nnn?