Formatting exponentials in Excel

[Niall 84]

I am trying to set up a spreadsheet that has a formula for the
available space which is = total - used

The thing is the space is GB or MB (1x10^9 or 1x10^6)

I formatted the numbers to display 1000000 as 1.00E+06 but is there
anyway of making this into 1MB so it will still calculate correctly?

Hope that makes sense,

Thanks,

Niall.

 

[RagDyeR]

Custom format

#,,\M\B
OR
#.#,,\M\B
OR
#.0,,\M\B
OR
0.0,,\M\B

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I am trying to set up a spreadsheet that has a formula for the
available space which is = total - used

The thing is the space is GB or MB (1x10^9 or 1x10^6)

I formatted the numbers to display 1000000 as 1.00E+06 but is there
anyway of making this into 1MB so it will still calculate correctly?

Hope that makes sense,

Thanks,

Niall.

 

[Niall 84]

Kool,

but how exactly do I use it?

Having a little trouble making it work.

Say for example C29 is 1Gig and D29 is 200Meg how can I get 800Meg in
E29 for the total? Thanks,

Niall

 

[Ron Rosenfeld]

I am trying to set up a spreadsheet that has a formula for the
available space which is = total - used

The thing is the space is GB or MB (1x10^9 or 1x10^6)

I formatted the numbers to display 1000000 as 1.00E+06 but is there
anyway of making this into 1MB so it will still calculate correctly?

Hope that makes sense,

Thanks,

Niall.

You could use a custom format:

[>=1000000000]#.0,,,"GB";[>=1000000]#.0,,"MB";#,###

If you need more precision displayed, add some "0's" to the one that is there.
--ron

 

[Niall 84]

I am trying to set up a spreadsheet that has a formula for the
available space which is = total - used

The thing is the space is GB or MB (1x10^9 or 1x10^6)

I formatted the numbers to display 1000000 as 1.00E+06 but is there
anyway of making this into 1MB so it will still calculate correctly?

Hope that makes sense,

Niall.

You could use a custom format:

[>=1000000000]#.0,,,"GB";[>=1000000]#.0,,"MB";#,###

If you need more precision displayed, add some "0's" to the one that is there.
--ron

Brilliant,

Works a charm!!!

Thanks a million.

 

[Ron Rosenfeld]

I am trying to set up a spreadsheet that has a formula for the
available space which is = total - used

The thing is the space is GB or MB (1x10^9 or 1x10^6)

I formatted the numbers to display 1000000 as 1.00E+06 but is there
anyway of making this into 1MB so it will still calculate correctly?

Hope that makes sense,

Niall.

You could use a custom format:

[>=1000000000]#.0,,,"GB";[>=1000000]#.0,,"MB";#,###

If you need more precision displayed, add some "0's" to the one that is there.
--ron

Brilliant,

Works a charm!!!

Thanks a million.

Glad to help.

Thanks for the feedback.
--ron