Currency Custom Format
Is it possible to custom format currency in a cell to round to something
other than a dollar? Example: $20,865.20 needs to display as $20,9 or $20.9 (including rounding) Is this even possible? I realize this is not the best way to display $ but need to shrink values to fit into a complicated file. Thanks for your help! -- B Rager |
Currency Custom Format
Try this custom number format Format|Cells - Number - Custom
$#,.# -- HTH... Jim Thomlinson "B Rager" wrote: Is it possible to custom format currency in a cell to round to something other than a dollar? Example: $20,865.20 needs to display as $20,9 or $20.9 (including rounding) Is this even possible? I realize this is not the best way to display $ but need to shrink values to fit into a complicated file. Thanks for your help! -- B Rager |
Currency Custom Format
Thank you so much! Worked perfectly.
-- B Rager "Jim Thomlinson" wrote: Try this custom number format Format|Cells - Number - Custom $#,.# -- HTH... Jim Thomlinson "B Rager" wrote: Is it possible to custom format currency in a cell to round to something other than a dollar? Example: $20,865.20 needs to display as $20,9 or $20.9 (including rounding) Is this even possible? I realize this is not the best way to display $ but need to shrink values to fit into a complicated file. Thanks for your help! -- B Rager |
All times are GMT +1. The time now is 10:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com