Posted to microsoft.public.excel.misc

nastech

Posts: n/a

Custom Format syntax Q

Hi, tyrying to format cells so combinations of following look like:
1M 15B (possibly 1.5M) thanks.

samples how received:

1.551M
..071B

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 Text	Frank & Pam Hayes	Excel Discussion (Misc queries)	3	December 3rd 05 05:36 PM
Is it possible to create your own custom format?	Scott Steiner	Excel Discussion (Misc queries)	5	November 22nd 05 05:46 PM
Custom number format button	Ken G.	Excel Discussion (Misc queries)	4	November 17th 05 05:59 AM
Custom Format to divide by 10	Ailish	Excel Discussion (Misc queries)	2	October 26th 05 05:04 PM
Custom Time Format doesn't work for me	chuck	Excel Discussion (Misc queries)	1	February 13th 05 04:12 AM

All times are GMT +1. The time now is 11:42 PM.

About Us

"It's about Microsoft Excel"