If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Accounting Category Display does not show the correct format/outpu
My apologies if this is a known bug or I am missing something...
On a worksheet in a spreadsheet, I have some cells already having numeric values in. When I try and format to Accounting Category, they remain as eg 4.4, 0.9 left justified, rather than 4.40 and 0.90 right justified. I have inserted another column to no avail. Is there some global action on the active worksheet that is stopping me changing the format? When I look at the format cells, it does say that the cells are Accounting and 2 decimal places In fact whatever I change it to, the cells remain the same value/output display. -- Thank you in advance. |
#2
|
|||
|
|||
Accounting Category Display does not show the correct format/outpu
Your "numbers" are actually text.
Copy an empty cell. Select your "numbers". EditPaste special, check Add. -- Kind regards, Niek Otten "per-ardua-ad-astra" wrote in message ... My apologies if this is a known bug or I am missing something... On a worksheet in a spreadsheet, I have some cells already having numeric values in. When I try and format to Accounting Category, they remain as eg 4.4, 0.9 left justified, rather than 4.40 and 0.90 right justified. I have inserted another column to no avail. Is there some global action on the active worksheet that is stopping me changing the format? When I look at the format cells, it does say that the cells are Accounting and 2 decimal places In fact whatever I change it to, the cells remain the same value/output display. -- Thank you in advance. |
#3
|
|||
|
|||
Accounting Category Display does not show the correct format/o
Niek
Thanks for the rapid response. I initially thought that this was a possibility but I am convinced that the number is a number and not text. I did as you said but the value remained the same. I also copied and special pasted (add) another number from another part of the spreadsheet and it added it to the field value, but leaving the format left justified. My apologies if I am missing something glaring in my face. -- Thank you in advance. "Niek Otten" wrote: Your "numbers" are actually text. Copy an empty cell. Select your "numbers". EditPaste special, check Add. -- Kind regards, Niek Otten "per-ardua-ad-astra" wrote in message ... My apologies if this is a known bug or I am missing something... On a worksheet in a spreadsheet, I have some cells already having numeric values in. When I try and format to Accounting Category, they remain as eg 4.4, 0.9 left justified, rather than 4.40 and 0.90 right justified. I have inserted another column to no avail. Is there some global action on the active worksheet that is stopping me changing the format? When I look at the format cells, it does say that the cells are Accounting and 2 decimal places In fact whatever I change it to, the cells remain the same value/output display. -- Thank you in advance. |
#4
|
|||
|
|||
Accounting Category Display does not show the correct format/o
What happens if you do a test with ISNUMBER()?
-- Kind regards, Niek Otten "per-ardua-ad-astra" wrote in message ... Niek Thanks for the rapid response. I initially thought that this was a possibility but I am convinced that the number is a number and not text. I did as you said but the value remained the same. I also copied and special pasted (add) another number from another part of the spreadsheet and it added it to the field value, but leaving the format left justified. My apologies if I am missing something glaring in my face. -- Thank you in advance. "Niek Otten" wrote: Your "numbers" are actually text. Copy an empty cell. Select your "numbers". EditPaste special, check Add. -- Kind regards, Niek Otten "per-ardua-ad-astra" wrote in message ... My apologies if this is a known bug or I am missing something... On a worksheet in a spreadsheet, I have some cells already having numeric values in. When I try and format to Accounting Category, they remain as eg 4.4, 0.9 left justified, rather than 4.40 and 0.90 right justified. I have inserted another column to no avail. Is there some global action on the active worksheet that is stopping me changing the format? When I look at the format cells, it does say that the cells are Accounting and 2 decimal places In fact whatever I change it to, the cells remain the same value/output display. -- Thank you in advance. |
#5
|
|||
|
|||
Accounting Category Display does not show the correct format/o
BTW, slight modification of my procedure should help:
Format an empty cell as Number. Enter zero. Copy. Select your "numbers". EditPaste Special, check "Add" This *should* work! -- Kind regards, Niek Otten "Niek Otten" wrote in message ... What happens if you do a test with ISNUMBER()? -- Kind regards, Niek Otten "per-ardua-ad-astra" wrote in message ... Niek Thanks for the rapid response. I initially thought that this was a possibility but I am convinced that the number is a number and not text. I did as you said but the value remained the same. I also copied and special pasted (add) another number from another part of the spreadsheet and it added it to the field value, but leaving the format left justified. My apologies if I am missing something glaring in my face. -- Thank you in advance. "Niek Otten" wrote: Your "numbers" are actually text. Copy an empty cell. Select your "numbers". EditPaste special, check Add. -- Kind regards, Niek Otten "per-ardua-ad-astra" wrote in message ... My apologies if this is a known bug or I am missing something... On a worksheet in a spreadsheet, I have some cells already having numeric values in. When I try and format to Accounting Category, they remain as eg 4.4, 0.9 left justified, rather than 4.40 and 0.90 right justified. I have inserted another column to no avail. Is there some global action on the active worksheet that is stopping me changing the format? When I look at the format cells, it does say that the cells are Accounting and 2 decimal places In fact whatever I change it to, the cells remain the same value/output display. -- Thank you in advance. |
#6
|
|||
|
|||
Accounting Category Display does not show the correct format/o
Niek,
Just tried your advice. The solution in the end was....Formula View ! I showed that the number was true using your suggestion with ISNUMBER() and this of course showed as a formula initially. On changinging from Formula View, the numbers displayed as correct format. A simple problem staring me in the face and I thank you again for your input. -- Thank you "Niek Otten" wrote: BTW, slight modification of my procedure should help: Format an empty cell as Number. Enter zero. Copy. Select your "numbers". EditPaste Special, check "Add" This *should* work! -- Kind regards, Niek Otten "Niek Otten" wrote in message ... What happens if you do a test with ISNUMBER()? -- Kind regards, Niek Otten "per-ardua-ad-astra" wrote in message ... Niek Thanks for the rapid response. I initially thought that this was a possibility but I am convinced that the number is a number and not text. I did as you said but the value remained the same. I also copied and special pasted (add) another number from another part of the spreadsheet and it added it to the field value, but leaving the format left justified. My apologies if I am missing something glaring in my face. -- Thank you in advance. "Niek Otten" wrote: Your "numbers" are actually text. Copy an empty cell. Select your "numbers". EditPaste special, check Add. -- Kind regards, Niek Otten "per-ardua-ad-astra" wrote in message ... My apologies if this is a known bug or I am missing something... On a worksheet in a spreadsheet, I have some cells already having numeric values in. When I try and format to Accounting Category, they remain as eg 4.4, 0.9 left justified, rather than 4.40 and 0.90 right justified. I have inserted another column to no avail. Is there some global action on the active worksheet that is stopping me changing the format? When I look at the format cells, it does say that the cells are Accounting and 2 decimal places In fact whatever I change it to, the cells remain the same value/output display. -- Thank you in advance. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
I used to be able to show my tasks by category now I can't? | Alan | General Discussion | 1 | November 22nd, 2005 04:16 AM |
Slide Show won't display.... | JEM | Powerpoint | 2 | October 7th, 2004 11:06 AM |
Adding New Display Fields in a Query to Show up on a Form | Mike | Using Forms | 1 | June 3rd, 2004 01:28 AM |
PowerPoint 97 - using a projector to display show | Lu | Powerpoint | 3 | May 27th, 2004 05:02 PM |
Appointments do not display the correct time since daylight savings time change | Vic Abrahamian | Installation & Setup | 0 | May 12th, 2004 12:26 AM |