Displaying 5000

[Guest]

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.

 

[Guest]

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

Click the [OK] button

Does that help?

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

XL2002, WinXP-Pro

 

[Anne Troy]

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

 

[Dave Peterson]

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.