[libreoffice-users] calc: treating text as zero

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+help@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