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
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