ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I get numbers converted to cost? (https://www.excelbanter.com/excel-discussion-misc-queries/86173-how-do-i-get-numbers-converted-cost.html)

mav40121

How do I get numbers converted to cost?
 
I am trying to type budget items, and I know there is a way to type 36.62
then move to a new cell and the that cell be automatically converted to
$36.42. I just don't know how to do it.

Richard

How do I get numbers converted to cost?
 
Select the relevant cells/columns
Click on Format
Click on Cells
Choose Curreny, symbol and decimal places
Click OK
--
Richard


"mav40121" wrote:

I am trying to type budget items, and I know there is a way to type 36.62
then move to a new cell and the that cell be automatically converted to
$36.42. I just don't know how to do it.



All times are GMT +1. The time now is 07:43 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com