Posted to microsoft.public.excel.misc

Doug

external usenet poster

Posts: 460

Truncating numbers to show last three digits

I need to figure out how to have the numbers truncated as follows:

$25.00 = $5.00
$22.00 = $2.00
$13.50 = $3.50
$10.00 = $0.00
--
Doug

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Truncating whole numbers - diplaying thousands instead of full num	Reez	Excel Discussion (Misc queries)	1	May 7th 07 04:29 PM
numbers truncating	Sue	Excel Discussion (Misc queries)	3	January 25th 07 12:52 PM
Combo Box - Show only first two digits?	Gayla	Excel Discussion (Misc queries)	7	November 8th 06 06:08 AM
Truncating numbers	Susana C via OfficeKB.com	Excel Worksheet Functions	1	May 8th 06 04:42 PM
How do I shorten 10-digit # so only 6 digits show up?	swingkittenva	Excel Discussion (Misc queries)	3	January 6th 06 04:49 PM

All times are GMT +1. The time now is 03:50 PM.

About Us

"It's about Microsoft Excel"