Tagged Questions
2
votes
2answers
212 views
How do I mix formats in one cell?
I've got a string like
="Daily Avg: " &AVERAGE(C3:C13)
I'd like to be able to apply number formats within my cell's formula. Is this possible without custom scripts?
I've searched Google's ...
1
vote
1answer
1k views
In Google Spreadsheets, how can I highlight selected text in a cell and not the whole cell?
In my Google Spreadsheet, I have a lot of text in a cell and want to highlight a small portion of this text with a particular colour.
But, whenever I try to do this, the formatting gets applied to ...
3
votes
2answers
443 views
Format credit card numbers as four digit blocks in Google Spreadsheets
I have this credit card number in a Google Docs spreadsheet of the following format:
XXXXXXXXXXXXXXXX
How can I make it display like XXXX XXXX XXXX XXXX or XXXX-XXXX-XXXX-XXXX where they're in ...
