Tom

Posts: n/a

Custom Number Format for Weight

I have a formula that I would like to display the result as pounds and
ounces. I created and custom format that will display as (for example) "14.25
lbs" but I would like it to display as 14 lbs 4 oz. It must display as a
number and not text. Any help would be great!

Thanks,

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
Custom Number Format...	whitmore0112	Excel Worksheet Functions	2	January 25th 05 10:11 PM
How to format a number in Indian style in Excel?	Victor_alb	Excel Discussion (Misc queries)	2	December 21st 04 04:21 AM
Custom number format	E2engine	Excel Worksheet Functions	10	December 4th 04 02:33 PM
Custom Number Format for HEX address	TRI-V	Excel Worksheet Functions	1	December 3rd 04 10:20 PM
GET.CELL	Biff	Excel Worksheet Functions	2	November 24th 04 07:16 PM

All times are GMT +1. The time now is 04:02 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us