Is there any way to force calc to treat text in a cell as equivalent to
zero when a number is expected? I always thought that this was the
normal presumption, but it appears not to be, at least for LO 3.5.7.2,
Build ID: 3215f89-f603614-ab984f2-7348103-1225a5b under Win7.
In spreadsheets imported from Twin (remember MS_DOS?) I have many cells
marked "xxx.xx", which indicate to the human operator that if there is
to be a numerical entry there, it must be manually supplied, as opposed
to being automatically calculated or transferred. Neither blanks nor
numerical zeros provide the same visual clues.
t.r. jackson
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted