Posted to microsoft.public.excel.newusers

Jaelou

Posts: n/a

Stopping autoformat when replacing cells.

I'm trying to replace text cells that read 1-1, 1-2, 1-3, etc. to be 2-1,
2-2, 2-3, etc. I've been going to Find and finding "1-" and replacing with
"2-", which changes the 1-1, for example to 38749. What am I doing wrong?

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
Replacing blank cells	Chris Stammers	Excel Worksheet Functions	2	December 1st 05 01:41 PM
Replacing Values in Cells Via Formula	pclutts	Excel Worksheet Functions	1	November 10th 05 01:21 PM
how do you "select locked cells" w/o "select unlocked cells"?	princejohnpaulfin	Excel Discussion (Misc queries)	3	July 16th 05 03:53 AM
Counting only active cells	Sac73	Excel Discussion (Misc queries)	16	April 4th 05 05:49 AM
Convert data type of cells to Text,Number,Date and Time	Kevin	Excel Worksheet Functions	1	December 31st 04 12:57 PM

All times are GMT +1. The time now is 03:58 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us