Excel Question - Standardize Units Of Measurement

Bingo thought this was worth mentioning said

Okay so not sure if anyone here is an Excel Ninja or not but figured I’d try.

I run a report on our network. I wind up with a report of about 50 sites showing their bandwidth, usage, etc.

Problem is, our sites are all over the place and this system kicks out measurements in everything from bps, kbps, Mbps and Gbps.

I’m wanting to know if there is a relatively easy way to standardize all these values to Mbps since there are a few manual calculations that I run and I’m sick of having to manually change like 60 values to get them all to Mbps so that I can just copy/paste this into my template and get all my calculations run correctly.

I’d really, REALLY prefer to avoid having to run VB scripts since this is a report that gets shared around and people freak out when they get a sheet that wants to run macros.

Any ideas?