Excel_Format Cells_Numbers Tab_should have 'Measurements' setting.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jim - 28 Aug 2006 18:01 GMT

Excel suggestion. It would be great if the 'Format' cells "Numbers Tab" would
allow you to format numbers with either English or metric systems weight,
length and distance measurements.

If anyone knows how I can add a 'g' for grams within a cell with out
disruptiing the SUM function; please let me know.

Thanks,
Jim

Reply to this Message

Richard Buttrey - 28 Aug 2006 18:06 GMT

Is

#.0 "g"

any use?

Rgds

>Excel suggestion. It would be great if the 'Format' cells "Numbers Tab" would
>allow you to format numbers with either English or metric systems weight,
[quoted text clipped - 14 lines]
>
>http://www.microsoft.com/office/community/en-us/default.mspx?mid=80b2e6d5-8ab7-4
d49-9b34-3ce94dac7668&dg=microsoft.public.excel.worksheet.functions

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

Reply to this Message

Toppers - 28 Aug 2006 18:11 GMT

=SUM(A1:A100) & "g"

Or format cell Custom ==> 0.00"g"

HTH

> Excel suggestion. It would be great if the 'Format' cells "Numbers Tab" would
> allow you to format numbers with either English or metric systems weight,
[quoted text clipped - 14 lines]
>
> http://www.microsoft.com/office/community/en-us/default.mspx?mid=80b2e6d5-8ab7-4
d49-9b34-3ce94dac7668&dg=microsoft.public.excel.worksheet.functions

Reply to this Message

Arvi Laanemets - 28 Aug 2006 18:15 GMT

> Excel suggestion. It would be great if the 'Format' cells "Numbers Tab" would
> allow you to format numbers with either English or metric systems weight,
> length and distance measurements.
>
> If anyone knows how I can add a 'g' for grams within a cell with out
> disruptiing the SUM function; please let me know.

Custom format "#g"

Arvi Laanemets

Reply to this Message