Custom Format

F

finlain

Is there a way to format numbers in size/speed such as
mb/sec.
In IT when they are charting different server speeds and want
to show a table for the chart, the only place that I was able t
display mb/sec was on the x-axis.

Not sure if this is possible or not
 
P

Paul

finlain said:
Is there a way to format numbers in size/speed such as
mb/sec.
In IT when they are charting different server speeds and want
to show a table for the chart, the only place that I was able to
display mb/sec was on the x-axis.

Not sure if this is possible or not ?
Click to expand...

You can include whatever text you want when defining a custom number format,
such as
#,##0"mb/sec"
The cell contents remain a number (so it is quite valid to refer to the cell
in formulas that are expecting a number), but display the text appended to
the number. Type in 64 and you see 64mb/sec .
It has no meaning as a unit, as such; that is, if you divide a number of kb
(sic) by a number of seconds, it doesn't change to kb/sec rather than
mb/sec.
Is this what you want?
 
Top