• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 352
  • Last Modified:

Pasting Formatted Value Into New Cell, Not Underlying Value

I have an Excel 2007 spreadsheet with a column of dates (example: 02/12/2014). I have formatted that column to reflect the day of the week, (ie. Mon, Tue, ...) I now want to copy the formatted value only and paste it into a new column. I don't want the underlying date to be part of that new column, just the day of the week.

How do I accomplish this?
0
JJENSEN3
Asked:
JJENSEN3
  • 3
  • 2
1 Solution
 
Raheman M. AbdulSenior Infrastructure Support Analyst & Systems DeveloperCommented:
Use Paste special
click on values only
0
 
Dan CraciunIT ConsultantCommented:
You can use a formula.
=TEXT(A1, "dddd")

where A1 is a cell that contains your formatted (or unformatted, doesn't matter) data.

HTH,
Dan
0
 
JJENSEN3Author Commented:
Using "values only" still leaves the underlying (02/12/2014) as the value in the cell. The display is correct, but I need the value to be the day of the week as well.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
Dan CraciunIT ConsultantCommented:
@Raheman Mohammed Abdul: in this case, Paste Special->Values will get you the numeric value of the date. Not the day of the week.
0
 
JJENSEN3Author Commented:
Works perfect. Thank you.
0
 
Dan CraciunIT ConsultantCommented:
Glad I could help!
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now