Number Formatting

[Traceelewis71]

I have a spreadsheet with over 74K lines and I need 1 of my columns be a hard (absolute) number out to 2 places after the decimal point. for example. If I have 24 in a cell, I need it to be 24.00. when I change the formatting the view changes but the actual contents of the cell aren't changing. I have tried to use this: placing a 1.00 in a blank cell and copying and paste special of the formatting only...that isn't working. I've tried to use the custom feature under formatting by saying 0.## and that isn't working. Please help. I can't spend the time updating over 74K lines.

 

[philwojo]

Easiest way I know of is to highlight the range, right click and do a "Format Cells", then on the 'Number' tab change it to be "number" and then select 2 decimal places, this should then update all cells you highlighted to have 2 decimal places.

 

[Traceelewis71]

I've tried that and its only updating the view not the actual cell contents

 

[philwojo]

My fault, I misunderstood your request, I am not sure how to do that.

 

[philwojo]

Maybe this, but not sure if this is treated as numerical afterward or not, or if that matters to you.

=TEXT(A1,"#####.00")

You could do this on a separate worksheet and point back to the original cell, then copy and paste the values in to the range to update it after.

I would experiment on a sample sheet, not your real sheet so you don't mess anything up.

 

[Traceelewis71]

Thank you!!!! That worked.