Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Copy Value of cell in formula

Posted on 2016-10-11
1
Medium Priority
?
82 Views
Last Modified: 2016-10-11
Is it possible to copy the value of a cell using "=A2" instead of the formatted value?

For example, I have in Q6 on a sheet "22:08:07" which excel has correctly identified it as a time and formatted it as a custom rule as hh:mm:ss, and it works fine. However I need to put this value in another cell as part of a string value (as a report). So it reads:-
="The value of cell Q6 is currently " & Q6

Open in new window


Which reads out as:-
The value of cell Q6 is currently 0.922303240740741

Where I want it to read:-
The value of cell Q6 is currently 22:08:07

The values are copied in from other reports, and excel automatically guesses as the formatting (and does a good job), so I dont want to have to manually set the formatting of the cells, and even if I do change the formatting of Q6 from custom to general it changes it to 0.922303

Any ideas?
0
Comment
Question by:tonelm54
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 27

Accepted Solution

by:
ProfessorJimJam earned 2000 total points
ID: 41838137
use this

="The value of cell Q6 is currently " & TEXT(Q6,"hh:mm:ss")
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
Microsoft has changed the look and feel of Azure AD and Microsoft account sign-in pages so that you will have a more unified look and feel when moving between the two interfaces.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

609 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question