ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Make a number stand out in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/117016-make-number-stand-out-excel.html)

George

Make a number stand out in Excel
 
Can I circle a number in a cell in Excel to make it stand out, or is there
another way. The cell contains both words and numbers and I do not want to
highlight it. I only want to make the number part stand out.

David Biddulph

Make a number stand out in Excel
 
If you've got words and numbers in the cell, you can select the part you
want to emphasise and change the font and size, make it bold, italics,
underline, and change colour. Is that enough?
--
David Biddulph

"George" wrote in message
...
Can I circle a number in a cell in Excel to make it stand out, or is there
another way. The cell contains both words and numbers and I do not want
to
highlight it. I only want to make the number part stand out.




George

Make a number stand out in Excel
 
Thanks David, but no. It's in a very large spread sheet with a small font so
bold, colours and underlines don't really stand out when printed. I am
looking for some way to place a boarder or something eles around the number.

"David Biddulph" wrote:

If you've got words and numbers in the cell, you can select the part you
want to emphasise and change the font and size, make it bold, italics,
underline, and change colour. Is that enough?
--
David Biddulph

"George" wrote in message
...
Can I circle a number in a cell in Excel to make it stand out, or is there
another way. The cell contains both words and numbers and I do not want
to
highlight it. I only want to make the number part stand out.





Michael

Make a number stand out in Excel
 
George, one way is to draw a circle around the number and format it with no
fill. You can also change the size of the circle line and its color. I'm
afraid it will be tedious, though, if you have a lot of those. HTH
--
Sincerely, Michael Colvin


"George" wrote:

Thanks David, but no. It's in a very large spread sheet with a small font so
bold, colours and underlines don't really stand out when printed. I am
looking for some way to place a boarder or something eles around the number.

"David Biddulph" wrote:

If you've got words and numbers in the cell, you can select the part you
want to emphasise and change the font and size, make it bold, italics,
underline, and change colour. Is that enough?
--
David Biddulph

"George" wrote in message
...
Can I circle a number in a cell in Excel to make it stand out, or is there
another way. The cell contains both words and numbers and I do not want
to
highlight it. I only want to make the number part stand out.






All times are GMT +1. The time now is 01:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com