| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
problem with cell formatting
I have a problem.
In an excel spreadsheet I have a column that has part numbers, and is formatted 'general'. Some of the items would be MAR-123465 MAR-168735 MAR-23148 MAR-2208 MAR-1938 Okay, here is the problem. If I do a replace and try to replace the '-' in these fields with a blank (simply remove the dash) I end up getting MAR123467 MAR158735 MAR23148 Mar-08 Mar-38 When it removes the dash, it arbitrarily changes the format to "custom" and date. What can I do to get it to simply remove the dashes but let it show MAR2208 and MAR1938???? I'd appreciate any suggestions. thanks, ga George Applegate |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell formatting problem | Excel Discussion (Misc queries) | |||
| Excel 2003 print problem with conditional formatting cell selected | Excel Discussion (Misc queries) | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Conditioal formatting problem | Excel Discussion (Misc queries) | |||
| cell formatting problems | New Users to Excel | |||
Threaded Mode
