View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ramesh Babu Ramesh Babu is offline
external usenet poster
 
Posts: 3
Default Aligning numbers to the centre of the cell

I tried aligning the numbers to the centre of the cell and decimals using
custom format #.#????, I am getting space between the first and second
decimal as seen below 100.1 2 and in 100.3 45

10.1
100.1
100.1 2
100.1
1000.3 45

What should be done to ensure there is no gap between the decimal points?