Re: [libreoffice-users] Clearing formatting.

=Column A has number
Column B sees if value can be used in formula (=a+1)
Column C checks isnumber result
Column D checks is text result
Column E checks Format result
Column F checks Type result
Column G =col(a) but format set to $


123124TRUEFALSEF0v=$123.00C2-
'123124FALSETRUEF0l123C2-
`123124TRUEFALSEF0v$123.00C2-
\u201c123 #VALUE!FALSETRUEF0l\u201c123C2-
^123#VALUE!FALSETRUEF0l^123Â-


Interesting that a 'number is not a number but can be used in 
formula? But a numeric format is not applied since it is a label 
type?




+------------------------------------------------------------+
Michael D. Setzer II - Computer Science Instructor 
(Retired)
mailto:mikes@guam.net                       
mailto:msetzerii@gmail.com
Guam - Where America's Day Begins                     
G4L Disk Imaging Project maintainer
http://sourceforge.net/projects/g4l/
+------------------------------------------------------------+




-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy