[Solved] Remove .00 from whole numbers?

Discuss the spreadsheet application

[Solved] Remove .00 from whole numbers?

Postby MadCowCrazy » Mon May 27, 2019 8:18 pm

I'm creating a monthly expenditure spreadsheet for my food costs and am having trouble trying to figure out how to format it with and without decimal points.
What I want is basically this:
12.45€
8.13€
5€ <----- This number shows as 5.00€, how do I remove the .00?
9.75€

I'd rather not have to do custom formatting for every cell that has a non decimal number. Is it possible to do this? That I can select all cells in A and B and through some custom formatting have decimal points when it's needed and none for whole numbers?
Last edited by robleyd on Tue May 28, 2019 1:02 am, edited 1 time in total.
Reason: Tagged [Solved]
OpenOffice 4.1.4 on Windows 10
MadCowCrazy
 
Posts: 2
Joined: Mon May 27, 2019 8:11 pm

Re: Remove .00 from whole numbers?

Postby RusselB » Mon May 27, 2019 9:05 pm

Welcome to the Forums.
Does
Code: Select all   Expand viewCollapse view
General€
in the Format Code box of the Format Cells dialog (Numbers tab) work for you? It looked close in my test.
OpenOffice 4.1.6 and LibreOffice 6.0.6.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 5300
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Remove .00 from whole numbers?

Postby MadCowCrazy » Mon May 27, 2019 9:09 pm

Yes, this works :D
Thx for the quick help.
OpenOffice 4.1.4 on Windows 10
MadCowCrazy
 
Posts: 2
Joined: Mon May 27, 2019 8:11 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 17 guests