Libre office calc cell values

[Cody]

I am selecting all cells in the spread sheet, and the font verdana, ranged left.

So why, when I return to the individual cells does the font revert to arial ranged right?

And why when I select the whole column as currency, then delete the contents is the cell formatting deleted too? That is extremely unhelpful - having to reformat cells every time I need to correct a small error.

Is there any way around these two problems? to save me having to repeatedly reformat fonts and cell values… Thanks

[EarnestAl]

If you want all cells in the spreadsheet to use Verdana font then, in Sidebar > Styles (select Cell styles if Page or Drawing style is highlighted) right click the Default cell style, select the Font tab and select Verdana, OK.

@Cody

And why when I select the whole column as currency, then delete the contents is the cell formatting deleted too?

If I have a column of numbers formatted as currency that I then delete, if I type a number in a cell in that column it will show as currency after exiting cell edit mode (press Enter). How are you deleting the cell contents?

You can create a cell style for currency in your spreadsheet

1. Right click Default cell style in the Styles pane of the Sidebar and select New
2. In the dialogue, in the General tab, give the style a name, e.g. NZD
3. In the Numbers tab of the same dialogue, select your desired currency format, -$123.00 and OK
4. Select a range you want formatted as currency then double click NZD in the list of cell styles.