ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   number format (https://www.excelbanter.com/excel-discussion-misc-queries/168696-number-format.html)

boub_boub

number format
 
how can i close a number into a cicle ?

Bernard Liengme

number format
 
With a font that displays single digits within a circle
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"boub_boub" wrote in message
...
how can i close a number into a cicle ?




Ron Rosenfeld

number format
 
On Thu, 6 Dec 2007 04:08:01 -0800, boub_boub
wrote:

how can i close a number into a cicle ?


Just to add to Bernard wrote, there are fonts that show numbers enclosed in a
circle (e.g. WingDings2). But these "numbers" will be interpreted by Excel as
TEXT and you will not be able to use them in calculations as you would real
numbers.
--ron


All times are GMT +1. The time now is 01:45 AM.

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