Posted to microsoft.public.excel.programming

Greg Brow

external usenet poster

Posts: 29

formatting macro

Hi all

I have a series of numbers 123456789 and it is followed with a letter a

I need to show on a worksheet in this format 123-456-789a I cant work out
how to set the cell i have tried 000-000-000 but not sure how to get it to
recognise the letter after

Thanks in advance

greg

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
formatting macro help	[email protected]	Excel Discussion (Misc queries)	2	March 10th 09 12:53 PM
Formatting using Macro	simplymidori[_2_]	Excel Discussion (Misc queries)	4	April 11th 08 12:22 AM
Formatting for a Macro	Maggie	Excel Discussion (Misc queries)	3	February 28th 07 02:00 AM
Formatting via a macro	mike_vr	Excel Discussion (Misc queries)	3	November 8th 06 04:19 PM
Formatting macro	jbb16x99	Excel Programming	3	October 10th 03 10:22 PM

All times are GMT +1. The time now is 03:19 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us