Greg Brow

Posts: n/a

problem withcell format

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
Problem with wrap text format	Mitch	Excel Worksheet Functions	1	January 20th 05 09:46 AM
Problem with txt format	Nuno	Excel Discussion (Misc queries)	1	January 18th 05 04:11 PM
Format Painter button problem	Skip Bisconer	Excel Discussion (Misc queries)	3	December 24th 04 06:05 PM
problem with formatting cell to date format	Del	Excel Worksheet Functions	7	December 8th 04 05:14 PM
cut and paste format problem	Francis Hayes (The Excel Addict)	Excel Discussion (Misc queries)	1	December 7th 04 02:23 PM

All times are GMT +1. The time now is 01:43 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us