Number formatting

[Guest]

I have a number in Excel 475640.00 and I need it to be 4756.40. However the
entire column of numbers does not have the same amount of charcters. For
example in this column is also 61300 which should be 613.00 and 4567829.00
which should be 45678.29 I tried text fixed with but that didn't work
because of the different amount of charcters in each number. How can I
change this format so that all the numbers are correct?

 

[N Harkawat]

Would dividing it by 100 give you the same outcome?
Then
=A1/100 and copy across/down should do

 

[Ron Rosenfeld]

On Fri, 14 Jan 2005 11:31:04 -0800, KP Lost in Formatting <KP Lost in

I have a number in Excel 475640.00 and I need it to be 4756.40. However the
entire column of numbers does not have the same amount of charcters. For
example in this column is also 61300 which should be 613.00 and 4567829.00
which should be 45678.29 I tried text fixed with but that didn't work
because of the different amount of charcters in each number. How can I
change this format so that all the numbers are correct?

Put a 100 in some empty cell.

Edit/Copy

Select your column of numbers to be altered.

Edit/Paste Special: Divide


--ron