Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting cells
I have a column in Excel worksheet of sample labels (ex. MA06-2023). If I
try to globally replace the "MA06" with "06" the value is automatically changed to a date format or calculated to some number value (Julian date?). The cells are designated as text format and the format for the replaced value is designated and text format. How do I make it stop doing this and replace it with the values I want? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting cells
Use a leading apostrophe on the '06 replacement....it won't show on the sheet
but forces the TEXT format. Vaya con Dios, Chuck, CABGx3 "Iotastd" wrote: I have a column in Excel worksheet of sample labels (ex. MA06-2023). If I try to globally replace the "MA06" with "06" the value is automatically changed to a date format or calculated to some number value (Julian date?). The cells are designated as text format and the format for the replaced value is designated and text format. How do I make it stop doing this and replace it with the values I want? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting Cells? | Excel Worksheet Functions | |||
formatting cells | Excel Worksheet Functions | |||
Formatting Cells | Excel Discussion (Misc queries) | |||
Conditional Formatting Multiple cells based on 2 cells | Excel Worksheet Functions | |||
FORMATTING CELLS | Excel Worksheet Functions |