User Profile
snojoe10
Copper Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Excel
How do I protect borders and formatting when cutting text from a cell? I have a simple ss that I use to track my time at work. I want to keep my borders for printing a selected range of cells. I often want to cut text in multiple cells and paste elsewhere in a sheet. I don't want to lose the borders or format in the cut cells.614Views0likes0CommentsExcel cell formatting
A have a formula in a cell that I want to show as a date format as "04/26 to 05/02". The formula entered is "=A3&" to "&A87" Cell a3 is "4/26/2020" & Cell a87 is a formula "=A73+1" which adds my work week formatted in a long date format showing weekday, month, day, year. The cell in which the formula is entered shows "43947 to 43953" It is meant to show the beginning and end date of my work week. I've tried different date formulas to no avail.Solved1.3KViews0likes4Comments
Recent Blog Articles
No content to show