Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Format Cells
is there anyway I can apply a custom format to cells that
can show either whole numbers, or decimals points e.g A1=15 A2=15.5 I would like this to be the standard for all cells in my sheet. I know you can apply Custom formats using [ ] etc. Thanks Pete |
#2
|
|||
|
|||
If you use the General format, it will show the number of decimals that
you've entered in the cell. Pete wrote: is there anyway I can apply a custom format to cells that can show either whole numbers, or decimals points e.g A1=15 A2=15.5 I would like this to be the standard for all cells in my sheet. I know you can apply Custom formats using [ ] etc. Thanks Pete -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Hi Debra,
I've misinformed you, the spreadsheet I have is a results sheet. Some scores can be decimal, some whole e.g A1=15 (this time) A1=15.5 (next time) I don't want to have to keep formatting the cells, can it be done automatically as the numbers are entered (as there is a lot). is it possible to have dual format cells? Tnaks Pete |
#4
|
|||
|
|||
If you make the column wide enough to show all the decimals, but format it as
General, what do you see when the cell evaluates to 15? How about when it evaluates to 15.5? Pete wrote: Hi Debra, I've misinformed you, the spreadsheet I have is a results sheet. Some scores can be decimal, some whole e.g A1=15 (this time) A1=15.5 (next time) I don't want to have to keep formatting the cells, can it be done automatically as the numbers are entered (as there is a lot). is it possible to have dual format cells? Tnaks Pete -- Dave Peterson |
#5
|
|||
|
|||
Gotta Gun, I think I need shooting. I have formatted the cells as
General, and all works fine. Thanks PEte Dave Peterson wrote: If you make the column wide enough to show all the decimals, but format it as General, what do you see when the cell evaluates to 15? How about when it evaluates to 15.5? Pete wrote: Hi Debra, I've misinformed you, the spreadsheet I have is a results sheet. Some scores can be decimal, some whole e.g A1=15 (this time) A1=15.5 (next time) I don't want to have to keep formatting the cells, can it be done automatically as the numbers are entered (as there is a lot). is it possible to have dual format cells? Tnaks Pete -- Dave Peterson |
#6
|
|||
|
|||
Debra isn't wrong very often. I know I test 8 or 9 times before I post back
that one of her suggestions didn't work for me! (And then I use a pseudonym!) Pete wrote: Gotta Gun, I think I need shooting. I have formatted the cells as General, and all works fine. Thanks PEte Dave Peterson wrote: If you make the column wide enough to show all the decimals, but format it as General, what do you see when the cell evaluates to 15? How about when it evaluates to 15.5? Pete wrote: Hi Debra, I've misinformed you, the spreadsheet I have is a results sheet. Some scores can be decimal, some whole e.g A1=15 (this time) A1=15.5 (next time) I don't want to have to keep formatting the cells, can it be done automatically as the numbers are entered (as there is a lot). is it possible to have dual format cells? Tnaks Pete -- Dave Peterson -- Dave Peterson |
#7
|
|||
|
|||
Thank you for your continued support. <g
And Pete, I'm glad you got the formatting to work. Dave Peterson wrote: Debra isn't wrong very often. I know I test 8 or 9 times before I post back that one of her suggestions didn't work for me! (And then I use a pseudonym!) Pete wrote: Gotta Gun, I think I need shooting. I have formatted the cells as General, and all works fine. Thanks PEte Dave Peterson wrote: If you make the column wide enough to show all the decimals, but format it as General, what do you see when the cell evaluates to 15? How about when it evaluates to 15.5? Pete wrote: Hi Debra, I've misinformed you, the spreadsheet I have is a results sheet. Some scores can be decimal, some whole e.g A1=15 (this time) A1=15.5 (next time) I don't want to have to keep formatting the cells, can it be done automatically as the numbers are entered (as there is a lot). is it possible to have dual format cells? Tnaks Pete -- Dave Peterson -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#8
|
|||
|
|||
Your Brilliant, you've helped me so much in the past too
Thanks Deborah |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
format cells dialog box does not come up | Excel Discussion (Misc queries) | |||
How do I get brackets in format cells accounting? | Excel Discussion (Misc queries) | |||
Combining data (numeric format) in multiple cells into one cell (t | Excel Discussion (Misc queries) | |||
How do I format cells to a specific number of digits? | Excel Discussion (Misc queries) | |||
Find cells without multiple spacebars and format... | Excel Discussion (Misc queries) |