Is there a simple way to divide values in a cell by 1,000?
Let's say I have thousands of cells with numbers formatted as $...for example, $9,437. However, I want these all to display as $9.4 and then I'll put a $k in the header. The $9,437 number is hard coded. How can I do this to thousands of numbers quickly? The only way I know is to use a new column, do a formula there, then copy and paste as values. Is there a faster/better way to do it right inside the existing cell?
Thanks,
Dave
Let's say I have thousands of cells with numbers formatted as $...for example, $9,437. However, I want these all to display as $9.4 and then I'll put a $k in the header. The $9,437 number is hard coded. How can I do this to thousands of numbers quickly? The only way I know is to use a new column, do a formula there, then copy and paste as values. Is there a faster/better way to do it right inside the existing cell?
Thanks,
Dave