View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default number formatting

Hi Sandy

Who knows???

Columns and rows seem to have been used

please help me put all columns in one straight line


If the OP does both, then hopefully that will resolve the problem
--
Regards

Roger Govier


"Sandy Mann" wrote in message
...
I read it differently:

i want all the decimal points to be in line for entire rows....


Try formatting the Column: Format Cells Number and selecting the
number of decimal places you want.
--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Roger Govier" wrote in message
...
Hi

Click on column heading, FormatCellsAlignmentHorizontalRight

--
Regards

Roger Govier


"Sam" wrote in message
...
i want all the decimal points to be in line for entire rows....for
example
2333.21
233.21
23.21
2.21
please help me put all columns in one straight line

--
Sam H