hi,

write the number 100 in a cell, make a copy of this cell, select the range and do a paste special - division

--
isabelle



Le 2012-08-30 16:42, a écrit :
On Thursday, April 3, 2008 8:42:00 PM UTC-5, SITCFanTN wrote:
I have a spreadsheet where the currency value are formatted incorrectly.
Values of 227.00 are shown as $22,700.00, 136.00 is shown as $13,600.00 aqnd 1331.00 is shown as 133,100.00.
I need all the values in column I to be divided by 100 with the $ sign omitted. Can anybody help me with the VB code for this.

Thanks so much

Thanks a lot for your help..
Really appreciate it