Changing a xcel decimal from implicit to explicit 1

[weberm]

I have a spreadsheet with a column containing dollar amount sans decimal, ie., 10.50 appears as 1050. How do I get the decimal to appear correctly? I tried to format the column but it gives me 1050.00...

 

[SkipVought]

Hi,

Tools > Options > Edit TAB -- CHECK Fixed Decimal Places and provide the number.

HOWEVER, that only works for NEW values that you enter or edit.

For existing values...

enter 100 in an empty cell.

COPY the cell

Select the CELLS containing unconverted values

Edit > Paste Special - DIVIDE

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[weberm]

Thank you!