Posted to microsoft.public.excel.worksheet.functions

Gord Dibben Gord Dibben is offline

external usenet poster

Posts: 22,906

need help formating a cell

Pre-format cells as Text

Enter 2-1-1

Drag/copy down

Gord Dibben MS Excel MVP

On Sun, 20 Jul 2008 23:01:00 -0700, Rama
wrote:

i am trying to type 2-1-1 in a cell and want the next cell to be 2-1-2 and so
on. But my cell keeps coming up a 36893. i have tried formating cell to
general and custom.

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
formating a cell	UniStudent Coll[_2_]	Excel Discussion (Misc queries)	2	February 26th 08 11:17 PM
FORMATING WITHIN CELL	BIG D	Excel Worksheet Functions	5	November 2nd 07 01:49 AM
Formating cell	bimseun	Excel Worksheet Functions	5	June 28th 06 10:17 PM
Cell to follow content AND/OR formating of another cell	0-0 Wai Wai ^-^	Excel Discussion (Misc queries)	1	September 8th 05 02:00 PM
cell formating	Pat DeStasio	Excel Worksheet Functions	2	April 9th 05 10:23 PM

All times are GMT +1. The time now is 05:51 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us