Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Stopping autoformat when replacing cells.
Hi
Excel is treating 1-1 etc as a date - and hence it comes up with 38749 (which is 1st Feb). I would suggest either formatting the cells to Text before you start or prefixing your entries with ' Andy. "Jaelou" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Stopping autoformat when replacing cells.
Thank you so much! All fixed!
"Andy" wrote: Hi Excel is treating 1-1 etc as a date - and hence it comes up with 38749 (which is 1st Feb). I would suggest either formatting the cells to Text before you start or prefixing your entries with ' Andy. "Jaelou" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Stopping autoformat when replacing cells.
Thanks for the feedback!
Andy. "Jaelou" wrote in message ... Thank you so much! All fixed! "Andy" wrote: Hi Excel is treating 1-1 etc as a date - and hence it comes up with 38749 (which is 1st Feb). I would suggest either formatting the cells to Text before you start or prefixing your entries with ' Andy. "Jaelou" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replacing blank cells | Excel Worksheet Functions | |||
Replacing Values in Cells Via Formula | Excel Worksheet Functions | |||
how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
Counting only active cells | Excel Discussion (Misc queries) | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |