Posted to microsoft.public.excel.programming

Kevin McCartney[_2_] Kevin McCartney[_2_] is offline

external usenet poster

Posts: 32

How To: Use Cell("Format") to return MMMM YYYY instead of D3

Hi
I'm trying to get the format property of a of a cell with using macros just using worksheet functions. When I use Cell("Format",A1) it returns D3, but I need the MMMM YYYY custom format that I have placed on the cell to be returned, any ideas how to get it

TI
KM

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
TEXT(Cell1,"MMMM YYYY") to work in all locale.	Jonathan Rynd	Excel Programming	0	February 12th 04 06:33 PM
TEXT(Cell1,"MMMM YYYY") to work in all locale.	Kevin McCartney[_2_]	Excel Programming	1	February 12th 04 02:10 PM
TEXT(Cell1,"MMMM YYYY") to work in all locale.	Kevin McCartney[_2_]	Excel Programming	2	February 12th 04 01:36 PM
TEXT(Cell1,"MMMM YYYY") to work in all locale.	Dianne	Excel Programming	0	February 10th 04 04:28 PM
TEXT(Cell1,"MMMM YYYY") to work in all locale.	arno	Excel Programming	0	February 10th 04 07:35 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us