Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions

JustSomeGuy JustSomeGuy is offline

external usenet poster

Posts: 1

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
Install dates formating using conditional formating?	Jerry Eggleston	Excel Discussion (Misc queries)	2	November 9th 05 05:49 PM
Formating output.	JustSomeGuy	Excel Discussion (Misc queries)	12	November 29th 04 09:03 PM
Formating output.	JustSomeGuy	Excel Worksheet Functions	12	November 29th 04 09:03 PM
Write to Output Type Formating	Dan T[_3_]	Excel Programming	1	July 10th 04 02:25 AM
Getting output from an excel output back to cscript..	J S	Excel Programming	0	January 21st 04 09:06 PM

All times are GMT +1. The time now is 09:49 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us