ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   $ and 0.00 (https://www.excelbanter.com/excel-discussion-misc-queries/195127-%24-0-00-a.html)

Catarina

$ and 0.00
 
How do I get the $ to appear left justified and 0.00 to appear decimal
justified in an cell? Thank you!

Ksmith916

$ and 0.00
 
If you format the cells as "accounting" it should work.

"Catarina" wrote:

How do I get the $ to appear left justified and 0.00 to appear decimal
justified in an cell? Thank you!


John C[_2_]

$ and 0.00
 
Format--Cells--Numbers, choose Accounting, and select $ to appear.
--
John C


"Catarina" wrote:

How do I get the $ to appear left justified and 0.00 to appear decimal
justified in an cell? Thank you!



All times are GMT +1. The time now is 07:17 PM.

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