View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Aline Aline is offline
external usenet poster
 
Posts: 43
Default Formatting Columns

I need to find a quick way to format columns of data from being shown in the
thousands to being shown in the eaches. For example, data given:
23.450
42.011
385.002

Data needed to be shown:
23,450
42,011
385,002

Is there a quick and easy way (such as a function or a format) to just
change the numbers within the cells rather than making a whole new table and
pasting that new data over my old data?