Forum Discussion
dlabrie
Sep 25, 2024Copper Contributor
Keeping Leading 0 in Cell Data not just Cell Display
I need the data in a cell to keep the leading 0 without adding an ' to the cell data. I am uploading to a program that pulls the actual cell data, and the lack of the leading 0 or the addition of th...
SergeiBaklan
Sep 25, 2024Diamond Contributor
With "Remove leading zero..." disabled Excel adds apostrophe if the cell was formatted as General
If blank cell is formatter as text when apostrophe is not added when you insert value into such cell.
Please note, cell shall be really blank, it's not enough to Del the value, all properties shall be reset. The easiest way is copy/paste blank cell from any place in the workbook where was no data.