# Revision history [back]

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.

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.