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?

looks like all numbers need to be multiplied by 1000. if so thn put 1000 in
a cell, copy it, select the cells to change and editpaset specialmultiply.
Format the cells to have the comma seperator
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Aline" wrote:

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?