On 08/04/2022 08:40, Michael D. Setzer II wrote:
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 $ 123124TRUE FALSEF0v$123.00C2- '123124FALSETRUEF0l123C2- `123124TRUEFALSEF0v$123.00C2- “123#VALUE!FALSETRUEF0l“123C2- ^123#VALUE!FALSETRUEF0l^123C2-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?
Yes, that got me interested. -- 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