Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Figured it out!

Any other number format is not automatically changed; it's almost like General is a 'blank' number format. Ie. formatting as General is equivalent to clearing the number format.

So the solution is to format as General"", which is equivalent to General in function, but is not a 'blank' number format so is not changed to standard form.

click to hide/show revision 2
Solution doesn't work. :-(

Figured it out!

Any other number format is not automatically changed; it's almost like General is a 'blank' number format. Ie. formatting as General is equivalent to clearing the number format.

So the solution is to format as General"", which is equivalent to General in function, but is not a 'blank' number format so is not changed to standard form.

Edit: Unfortunately, General"" doesn't persist across saves!!

Figured it out!

Any other number format is not automatically changed; it's almost like General is a 'blank' number format. Ie. formatting as General is equivalent to clearing the number format.

So the solution is to format as General""General;General, which is equivalent to General in function, but is not a 'blank' number format so is not changed to standard form.

Edit: Unfortunately, General"" doesn't persist across saves!!

Figured it out!

Any other number format is not automatically changed; it's almost like General is a 'blank' number format. Ie. formatting as General is equivalent to clearing the number format.

So the solution is to format as General;General, which is equivalent to General in function, but is not a 'blank' number format so is not changed to standard form.