I forgot to mention:
All the formatting attributes, colors, fonts, borders including the
number format locale an the number formats, have absolutely no impact on
existing cell's value nor formula results. No formatting attribute will
ever change a numeric value or convert numbers to text or text to number.
I put =PI() into 11 cells and applied several number formats without
changing one single value:
3.14159 [dotted 5 decimals]
3,14 € [comma Euro]
$3.14 [Dollar dot]
314.1593% [percent]
3 1/7 [fraction]
3.14E+000 [scientific]
1900-01-02 [ISO date only]
03:23:54 [ISO time only]
1900-01-02 03:23:54 [ISO date+time]
Tuesday, January 02, 1900 [US long date]
TRUE [Boolean]
PI() is day number 3 plus some 0.14159 of a day. Day zero is 1899-12-30
00:00 (Excel compatible).
When you modify the zero time in the calc options, you may get different
dates from the same numeric values. This should never be necessary
unless you copy date numbers from different applications.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
