Ask Your Question
0

MB and GB Hidding zero's [closed]

asked 2013-04-03 10:18:01 +0200

alabandit gravatar image

I'm working on a table that has a large number of MegaByte, GigaByte and TeriByte Values. For the simplicity of math I assume every thing less than 1 is a KiloByte and all cells are MegaByte (Base 1000 not 1024).

Currently cell are formatted to have a tailing MB

Example:

Photos    | Documents     | Videos
----------+---------------+------------------    
53.768 MB | 13 589.378 MB | 27 879 321.558 MB

Is there an easy way to format cells to hide the last 3 zero's but maintain the full value, so people reading the table would see:

Photos    | Documents     | Videos
----------+---------------+----------    
53.768 MB | 13.589 GB     | 27.879 TB

or:

Photos    | Documents | Videos
----------+-----------+----------    
53 MB     | 13 GB     | 27 TB

This would make it a lot easier to read, but cannot compromise the underlining maths. I would still need to be able to multiple 27TB by 2 and get 55758643,116 not 54.

Thanks for your help.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-28 02:24:28.769131

1 Answer

Sort by » oldest newest most voted
2

answered 2013-04-03 14:55:31 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Got the answer here: http://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=60863&p=269361#p269361

If your data are numeric and if they are entered with the same unity (MB), Format > Cell, define this format :

[>1000000]0.000,," TB";[>1000]0.000," GB";0.000" MB"

Note there is one space between 0.000 and " GB" and 2 spaces between 0.000 and " TB". (of course no space for MB)

For French locale [>1000000]0,000 " TB";[>1000]0,000 " GB";0,000" MB"

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2013-04-03 10:18:01 +0200

Seen: 2,510 times

Last updated: Apr 03 '13