Re: Bullets and numbers

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Alt + 0149(on the numpad) then the number.

Note: this will format the cell as text.

Alternative if you want the number to stay as a number...........

Format>Cells>Number>Custom Alt + 0149 #,##0


Gord Dibben MS Excel MVP

On Thu, 22 Feb 2007 05:05:30 -0800, OnWire <OnWire@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:

How can i use bullets and numbers within a cell?

.

Relevant Pages

  • Re: Sort imported date column
    ... Gord Dibben MS Excel MVP ... The same holds true for the the cell in which I ... You would think that a plain CSV wouldn't confuse ... that column, use Data/text to columns, in step 3 change the column Format to ...
    (microsoft.public.excel.misc)
  • Re: VLookup wont work
    ... Sounds like the cell was pre-formatted as Text. ... Format to General then hit F2 + ENTER ... Gord Dibben MS Excel MVP ...
    (microsoft.public.excel.misc)
  • Re: when importing .txt files can I separate the data horizontally
    ... I want to import it in this fashion- [brackets show what I need per cell] ... >> Gord Dibben MS Excel MVP ... >>>and I can't get the data to format properly. ... Then you can sort back via sort on A,B to get the original data list. ...
    (microsoft.public.excel.newusers)
  • Re: How do I enter a date typing 040906 and have it appear 04/09/0
    ... What you can do is to enter the dates into a column in the format you ... Gord Dibben MS Excel MVP ... date and have the cell display the date with the forward slashes added ... in the cell. ...
    (microsoft.public.excel.newusers)
  • Re: Data validation dont work
    ... Format all to General. ... Copy a blank cell. ... Gord Dibben MS Excel MVP ... If I enter the same value twice it takes. ...
    (microsoft.public.excel.misc)