paraDisE beyond the eArTH
Rinith Online
Pages
Home
Photo Albums
Reviving Memories
Drawings & Paintings
LiL Masters
Amazing Facts
Mindblowing Performers
How it's Made
Profile
Tuesday, 31 May 2016
Simple GB Convertion in Excel
Format bytes a cell in Excel as KB, MB, GB etc?
Right click a particular cell, Format the cell and apply a Custom category and add to the 'Type' field
[<1000000]0.00," KB";[<1000000000]0.00,," MB";0.00,,," GB"
works in office 2010 and above without any issues.
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)