Access Beginner
Active Member
- Joined
- Nov 8, 2010
- Messages
- 311
- Office Version
- 2016
- Platform
- Windows
Hi All,
I have cells, where the value can can vary from the millions to the tens of thousands.
Do you know of any custome format options, if the value is say 5,100,000 we can show this as 5.1M and if the value is say 320,500 we can show it as 320.5T.
Values are in a dynamic chart, so a user can select a region and the values update, for that particular region. The issue is where some regions can go into the millions, where others will only go into the hundreds of thousand and possibly tens of thousands
These values go into a dynamic chart and showing the value as 5,000,000 is taking up too much real estate. If all the values were in the million, this would not be a problem and I could use s aimpel customer format, however when the values vary as mentioned above, I'm stumped.
Any help/advice appreciated.
Cheers
I have cells, where the value can can vary from the millions to the tens of thousands.
Do you know of any custome format options, if the value is say 5,100,000 we can show this as 5.1M and if the value is say 320,500 we can show it as 320.5T.
Values are in a dynamic chart, so a user can select a region and the values update, for that particular region. The issue is where some regions can go into the millions, where others will only go into the hundreds of thousand and possibly tens of thousands
These values go into a dynamic chart and showing the value as 5,000,000 is taking up too much real estate. If all the values were in the million, this would not be a problem and I could use s aimpel customer format, however when the values vary as mentioned above, I'm stumped.
Any help/advice appreciated.
Cheers