JustSomeGuy

Posts: n/a

Formating output.

I have a number which is the size of a file on disk.
Depending on the size of the number I want to display it as either
1.5KB, or 2.0MB or .75GB or .5TB

However I want to be able to add up all the numbers in that column as normal
numbers and also format it the same way.

How do I do this.... I do know VB very well...

Brian.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Formating h:mm AM/PM	Mike R	Excel Discussion (Misc queries)	3	January 7th 05 02:12 AM
Formating, paragraph marks, boxes etc, how do I get rid of them?	Josh	Excel Discussion (Misc queries)	1	December 27th 04 08:33 PM
Formating	stevieray	Excel Discussion (Misc queries)	1	November 30th 04 11:30 PM
Formating output.	JustSomeGuy	Excel Discussion (Misc queries)	12	November 29th 04 09:03 PM
30 Day Aging Report Using Conditional Formating	Tiegris	Excel Worksheet Functions	0	November 4th 04 10:07 PM

All times are GMT +1. The time now is 02:18 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us