I have a student that wants to display 5 in a cell when the raw value is
5000. I tried the scientific format but do not want the E+3 to show. Any
ideas? Truncate? The thousands number will be changing.

Thanks in advance for any assistance offered.

Try something like this:
Select the cell(s)
FormatCellsNumber tab
Category: Custom
Type: #,###,
(note the trailing comma)

Click the [OK] button

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Andrea" wrote:

I have a student that wants to display 5 in a cell when the raw value is
5000. I tried the scientific format but do not want the E+3 to show. Any
ideas? Truncate? The thousands number will be changing.

Thanks in advance for any assistance offered.

Hit Format--Cells and choose Custom and type this into the box:
#,
(pound sign followed by a comma)
Be careful. Anything less that 1000 will show as blank.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Andrea" wrote in message
...
I have a student that wants to display 5 in a cell when the raw value is
5000. I tried the scientific format but do not want the E+3 to show. Any
ideas? Truncate? The thousands number will be changing.

Thanks in advance for any assistance offered.

Try a custom format of:
0,
(zero comma)

Note that the display changes--not the underlying value.

And the user still has to type in 5000.

Andrea wrote:

I have a student that wants to display 5 in a cell when the raw value is
5000. I tried the scientific format but do not want the E+3 to show. Any
ideas? Truncate? The thousands number will be changing.

Thanks in advance for any assistance offered.

--

Dave Peterson