Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Steve D
 
Posts: n/a
Default Changing the scale to custom text

Hello, I am trying to change my scale from say 5000 to 5k, is there any way
to do this?
--
Thank You,
Steve
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default Changing the scale to custom text

Hi,

Use as custom number format #,k

Cheer
Andy

Steve D wrote:
Hello, I am trying to change my scale from say 5000 to 5k, is there any way
to do this?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 132
Default Changing the scale to custom text

I can't get this to work it just brings up k instead of the number with K
after it do you know what I am doing wrong?

"Andy Pope" wrote:

Hi,

Use as custom number format #,k

Cheer
Andy

Steve D wrote:
Hello, I am trying to change my scale from say 5000 to 5k, is there any way
to do this?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Make Excel changing text case as easy as in Word!! Altrusan Excel Discussion (Misc queries) 0 January 25th 06 09:17 PM
Changing text to value Lynn Burrow Excel Discussion (Misc queries) 4 January 23rd 06 11:01 PM
Changing cell format - for example text to numeric sjrku Excel Discussion (Misc queries) 3 December 30th 05 10:40 PM
Can you link a custom property to an Excel custom header text? LouErc Setting up and Configuration of Excel 0 November 8th 05 04:58 PM
Why is my text changing to pound signs? SleepyDawn Excel Discussion (Misc queries) 2 February 9th 05 10:52 PM


All times are GMT +1. The time now is 11:57 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"