Excel number format for "less than" values

BrianBulla 

Thanks!

Some of these values have been entered as numbers, for example 0.12

The custom number format contains the fixed character < so the value is displayed as < 0.12

When you export the data to another application, you'll see 0.12 because that is the actual value of the cell.

Other values have been entered as displayed, complete with the character < in the value, for example < 0.12. Since < is part of the value, Excel treats it as text. The number format does not affect this, so whether the format is General or Text or 0.00 or < 0.00, Excel will display < 0.12

When you export to another application, you'll see < 0.12 - the real value of the cell.