Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

In trying to catch up here, I believe I see the situation. Here is a maybe depending upon what you are doing. You are generating this report from either a table or query. If you had just the data from that table or query in Calc would you have what is needed? I say this because you can bring registered data sources into Calc and it retains the original format:

image description

The figures in Col B were originally defined as a text field and both a table or query retains the leading zero. The cell format was not set prior but after data loaded it is Text.