conversion to thousand

I think this is what you need

For the 123 in A1

=A1*1000

Originally Posted by naveen2win

Hi,

I am trying to upload a .xls file to my database and in the amout column it has found that i have enterd all the amounts like (123).but i wanted to convert all the amounts to a thousand format for eg (123,000). Is there any inbult functionality available. Please help thanks.

Thanks
Nom

If you enter 1000 into any unoccupied cell and copy it, then select the column of numbers to convert and go to Edit|Paste Special...select Multiply...

This will multiply all your numbers by 1000 in place.