Hi Prashant,
Go to FORMAT CELL>Custom> _($#,k
this will solve your problem...
Cheers,
Bakul
--- On Thu, 4/9/09, Prashanth Banneni <praba...@gmail.com> wrote:
From: Prashanth Banneni <praba...@gmail.com>
Subject: $$Excel-Macros$$ Fwd: Convert $900,000 to $900k in graph
To: excel-macros@googlegroups.com
Date: Thursday, April 9, 2009, 12:24 AM
Hi All,
Any help on this please.
guess you understand the urgency.
Thanks,
Prashanth
---------- Forwarded message ----------
From: Prashanth Banneni <praba...@gmail.com>
Date: Thu, Apr 9, 2009 at 11:09 AM
Subject: Convert $900,000 to $900k in graph
To: excel-macros@googlegroups.com
Hi Team,
I have an urgent requirement.
i have a graph whose y axis has revenue from $0 to $900,000, now i want to
remove the last 000 and show as $100K, $200K, $300K, $400K......$900K.
Can any one let me know how to change it in the custom tab under Format Axis.
Need this help for a presentation this evening.
Thanks in advance.
Prashanth
Analyst
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
