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? |
Aligning numbers to the centre of the cell
Ramesh
It is always better to stay with the same thread. I tested the custom format RD supplied and do not get any spaces. If I add a space into the Custom format like this #.# ???? I see it as you do. Check your typing in the Custom Format Gord Dibben MS Excel MVP On Sat, 1 Jul 2006 14:56:01 -0700, Ramesh Babu wrote: 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? |
Aligning numbers to the centre of the cell
You should stay in the same thread where you originally asked your question,
so others can more easily follow the conversation. Anyhow ... I'm sure that you have a <space between the # and the first ? when you entered your format in the "Type" box. Check it out! -- Regards, RD ---------------------------------------------------------------------------- ------------------- Please keep all correspondence within the Group, so all may benefit ! ---------------------------------------------------------------------------- ------------------- "Ramesh Babu" wrote in message ... 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? |
All times are GMT +1. The time now is 10:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com