Have you ever exported a powershell script only to see values like 876755433?
Have you ever wanted an easy way to format that number auto-magically into a kb's mb's or gb's?
Use the following process:
In Excel
Select the column needed to format
Right click column header
Choose "Format Cells"
Choose the "Custom" option under the "Number" tab
Paste this value - [<1000]#,##0.00" KB ";[<1000000]#,##0.00," MB";#,##0.00,," GB"
And click OK
MAGIC!
No comments:
Post a Comment