Moriath
I am a FH squatter
- Joined
- Dec 23, 2003
- Messages
- 16,209
Nice. Too much chili for me
Nice. Too much chili for me
Hardly any chilli. Not very strong stuff - just crappy chillies from sainsbugs. Could barely feel the spice.Nice. Too much chili for me
It's a bit clunky but you can set up conditional formatting on the first cell with a formula:Need some Excel custom formatting help
How do I apply this rule to all numbers in a column:
IF the cell is zero, OR a whole number (eg 14) THEN no decimal places
ELSE display to 2 decimal places
Example
25.67 should display as 25.67
25.60 should display as 25.60
25.00 should display as 25
0.50 should display as 0.50
0 should display as 0, Not 0.00
Cheers
=SEARCH(".0",TEXT(x,"0.0"))
Get the power query plugin for Excel. Could handle that in a split secondNeed some Excel custom formatting help
How do I apply this rule to all numbers in a column:
IF the cell is zero, OR a whole number (eg 14) THEN no decimal places
ELSE display to 2 decimal places
Example
25.67 should display as 25.67
25.60 should display as 25.60
25.00 should display as 25
0.50 should display as 0.50
0 should display as 0, Not 0.00
Cheers
No idea tbh. If you round you'll lose the second dp if the value 2.20 or something, which breaks @Lamp's stupid rules.Can't you just use the ROUND function?
Code:=ROUND(x, 2)
You can do it in one go, you just need to put the correct formatting rule on the first cell in the column (as per my previous post) and then you can use the format painter to copy the format to all the cells below it. It will update the cell reference in the format formula for each one.Thanks mate
I've got 900 cells
Must be a way to format in one go
... a thing in some accounting circles
One of the girls we hung out with when I was younger..man she was a stunner, everyine wanted to bang her, but she never seemed to have a boyfriend.
She goes on holiday to America, comes back and starts telling some stories.
She casually says in front of everyone. ' I was dying for some coke, but didnt have any cash so some old guy put it on his dick and I sucked it off for payment'.
The entire room died.
Nicola McCann.
She turned into a total party animal, took me into town one night and we ended up in a Hells Angels bar, there was one guy sat in a fucking throne with two biker chicks at his feet.
He calls me over, pulls me close and says.
'You be good to her , we let her have her pretty boys'.
It was like a freakin movie.
Id love to know where she is now....boots up facebook.
Now thats funny.