[libreoffice-users] Problem formatting table column as currency

I set up a table.
Selected a column.
Went to 'Table>Number recognition' and turned it on
Selected 'Number format>Currency>-$1,234.00'
The top cell in the column reflected this change; none of the other 
cells reflected it when I entered numbers
I tried resetting the Number format several times with no success, even 
after first 'clear[ing] format'
I tried adding a new column, selecting it before entering anything, and 
made the same formatting change
None of the numbers I entered received the currency setting.

How do I get the whole column to show as currency?

Using LO 25.2.6.2 (X86_64) on Fedora 42 Workstation edition.

Thanks
--
Eric Beversluis
www.ericbeversluis.com
3x Honorable Mention--Writer's Digest Contest

--
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