Custom Number Format - 0 not displaying

[SawdustCollector]

I have this number format to display gigabyte units after numerical values.

#" GB"

When I enter a value of 0 in a cell with the formating, the zero does not diplay. Only the " GB" displays.

I would like "0 GB" to display. What is wrong with my number format?

Thanks in advance!
Don

 

[dreid1011]

I have this number format to display gigabyte units after numerical values.

#" GB"

When I enter a value of 0 in a cell with the formating, the zero does not diplay. Only the " GB" displays.

I would like "0 GB" to display. What is wrong with my number format?

Thanks in advance!
Don

Give this a try:

#0" GB"

Or even just this:

0" GB"

 

[Rick Rothstein]

I have this number format to display gigabyte units after numerical values.

#" GB"

When I enter a value of 0 in a cell with the formating, the zero does not diplay. Only the " GB" displays.

I would like "0 GB" to display. What is wrong with my number format?

The # sign does not display leading or trailing zeroes... I guess a 0 by itself is considered a leading zero. Try using this custom type pattern instead...

0" GB"

The 0 forces a zero in that spot when there is no digit to fill it.

 

[SawdustCollector]

Thanks! I knew it would be an easy fix. Haven't messed with number formats much.

 

[dreid1011]

Thanks! I knew it would be an easy fix. Haven't messed with number formats much.

You're welcome.