All Questions
3
questions
0
votes
1
answer
2k
views
Excel apply complicated formula to existing cells value without copy/paste
I want to apply the formula
=TEXT(A1,IF(A1-INT(A1)=0,"0","#.####"))
to existing cells with numbers without doing copy and paste.
The existing spreadsheet is already big and ...
67
votes
11
answers
263k
views
Excel copy-paste: always match destination formatting
I use Excel to crunch numbers, so I usually don't want to copy the formatting along with the text. But this is the default. Is there a way to default to always match destination formatting when ...
3
votes
3
answers
6k
views
Can I paste rich text and preserve formatting?
I have an Excel sheet and I paste text into a text box. I'm trying to copy+paste a source code from Eclipse and to preserve syntax highlighting and preserve tabs (code formatting).
Syntax ...