Cell formatted as 00\:00\:00 printing as ########

[HighAndWilder]

I have a column of data with values such as 4200 with a custom format of 00\:00\:00 but prints out as ########.

and should print out as 00:42:00.

It displays in the cell as 00:42:00 correctly.

What can I do to change how it prints out?

Thanks

 

[starl]

Have you tried making the column wider?

 

[HighAndWilder]

Have you tried making the column wider?

That worked.

I auto fitted the columns before printing and it looked fine in preview.

Thanks

 

[starl]

You're welcome. I really don't know why preview looked ok but the actual printout wasn't. There are some weird things in Excel, though that issue doesn't come often. Unless your preview printer was different than the actual printer you printed out of?