#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default $ and 0.00

How do I get the $ to appear left justified and 0.00 to appear decimal
justified in an cell? Thank you!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default $ 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!

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,358
Default $ 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!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 11:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"