software

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.

Your quot;numbersquot; are actually text.
Copy an empty cell.
Select your quot;numbersquot;.
Editgt;Paste special, check Add.

--
Kind regards,

Niek Otten

quot;per-ardua-ad-astraquot; gt; wrote in
message ...
gt; My apologies if this is a known bug or I am missing something...
gt;
gt; On a worksheet in a spreadsheet, I have some cells already having numeric
gt; values in. When I try and format to Accounting Category, they remain as
gt; eg
gt; 4.4, 0.9 left justified, rather than 4.40 and 0.90 right justified.
gt;
gt; I have inserted another column to no avail. Is there some global action
gt; on
gt; the active worksheet that is stopping me changing the format? When I look
gt; at
gt; the format cells, it does say that the cells are Accounting and 2 decimal
gt; places
gt;
gt; In fact whatever I change it to, the cells remain the same value/output
gt; display.
gt;
gt; --
gt; Thank you in advance.
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.quot;Niek Ottenquot; wrote:

gt; Your quot;numbersquot; are actually text.
gt; Copy an empty cell.
gt; Select your quot;numbersquot;.
gt; Editgt;Paste special, check Add.
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;per-ardua-ad-astraquot; gt; wrote in
gt; message ...
gt; gt; My apologies if this is a known bug or I am missing something...
gt; gt;
gt; gt; On a worksheet in a spreadsheet, I have some cells already having numeric
gt; gt; values in. When I try and format to Accounting Category, they remain as
gt; gt; eg
gt; gt; 4.4, 0.9 left justified, rather than 4.40 and 0.90 right justified.
gt; gt;
gt; gt; I have inserted another column to no avail. Is there some global action
gt; gt; on
gt; gt; the active worksheet that is stopping me changing the format? When I look
gt; gt; at
gt; gt; the format cells, it does say that the cells are Accounting and 2 decimal
gt; gt; places
gt; gt;
gt; gt; In fact whatever I change it to, the cells remain the same value/output
gt; gt; display.
gt; gt;
gt; gt; --
gt; gt; Thank you in advance.
gt;
gt;
gt;

What happens if you do a test with ISNUMBER()?

--
Kind regards,

Niek Otten

quot;per-ardua-ad-astraquot; gt; wrote in
message ...
gt; Niek
gt; Thanks for the rapid response. I initially thought that this was a
gt; possibility but I am convinced that the number is a number and not text.
gt; I
gt; did as you said but the value remained the same. I also copied and
gt; special
gt; pasted (add) another number from another part of the spreadsheet and it
gt; added
gt; it to the field value, but leaving the format left justified. My
gt; apologies
gt; if I am missing something glaring in my face.
gt; --
gt; Thank you in advance.
gt;
gt;
gt; quot;Niek Ottenquot; wrote:
gt;
gt;gt; Your quot;numbersquot; are actually text.
gt;gt; Copy an empty cell.
gt;gt; Select your quot;numbersquot;.
gt;gt; Editgt;Paste special, check Add.
gt;gt;
gt;gt; --
gt;gt; Kind regards,
gt;gt;
gt;gt; Niek Otten
gt;gt;
gt;gt; quot;per-ardua-ad-astraquot; gt; wrote in
gt;gt; message ...
gt;gt; gt; My apologies if this is a known bug or I am missing something...
gt;gt; gt;
gt;gt; gt; On a worksheet in a spreadsheet, I have some cells already having
gt;gt; gt; numeric
gt;gt; gt; values in. When I try and format to Accounting Category, they remain
gt;gt; gt; as
gt;gt; gt; eg
gt;gt; gt; 4.4, 0.9 left justified, rather than 4.40 and 0.90 right justified.
gt;gt; gt;
gt;gt; gt; I have inserted another column to no avail. Is there some global
gt;gt; gt; action
gt;gt; gt; on
gt;gt; gt; the active worksheet that is stopping me changing the format? When I
gt;gt; gt; look
gt;gt; gt; at
gt;gt; gt; the format cells, it does say that the cells are Accounting and 2
gt;gt; gt; decimal
gt;gt; gt; places
gt;gt; gt;
gt;gt; gt; In fact whatever I change it to, the cells remain the same value/output
gt;gt; gt; display.
gt;gt; gt;
gt;gt; gt; --
gt;gt; gt; Thank you in advance.
gt;gt;
gt;gt;
gt;gt;
BTW, slight modification of my procedure should help:

Format an empty cell as Number. Enter zero. Copy.
Select your quot;numbersquot;. Editgt;Paste Special, check quot;Addquot;
This *should* work!

--
Kind regards,

Niek Otten

quot;Niek Ottenquot; gt; wrote in message
...
gt; What happens if you do a test with ISNUMBER()?
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;per-ardua-ad-astraquot; gt; wrote in
gt; message ...
gt;gt; Niek
gt;gt; Thanks for the rapid response. I initially thought that this was a
gt;gt; possibility but I am convinced that the number is a number and not text.
gt;gt; I
gt;gt; did as you said but the value remained the same. I also copied and
gt;gt; special
gt;gt; pasted (add) another number from another part of the spreadsheet and it
gt;gt; added
gt;gt; it to the field value, but leaving the format left justified. My
gt;gt; apologies
gt;gt; if I am missing something glaring in my face.
gt;gt; --
gt;gt; Thank you in advance.
gt;gt;
gt;gt;
gt;gt; quot;Niek Ottenquot; wrote:
gt;gt;
gt;gt;gt; Your quot;numbersquot; are actually text.
gt;gt;gt; Copy an empty cell.
gt;gt;gt; Select your quot;numbersquot;.
gt;gt;gt; Editgt;Paste special, check Add.
gt;gt;gt;
gt;gt;gt; --
gt;gt;gt; Kind regards,
gt;gt;gt;
gt;gt;gt; Niek Otten
gt;gt;gt;
gt;gt;gt; quot;per-ardua-ad-astraquot; gt; wrote
gt;gt;gt; in
gt;gt;gt; message ...
gt;gt;gt; gt; My apologies if this is a known bug or I am missing something...
gt;gt;gt; gt;
gt;gt;gt; gt; On a worksheet in a spreadsheet, I have some cells already having
gt;gt;gt; gt; numeric
gt;gt;gt; gt; values in. When I try and format to Accounting Category, they remain
gt;gt;gt; gt; as
gt;gt;gt; gt; eg
gt;gt;gt; gt; 4.4, 0.9 left justified, rather than 4.40 and 0.90 right justified.
gt;gt;gt; gt;
gt;gt;gt; gt; I have inserted another column to no avail. Is there some global
gt;gt;gt; gt; action
gt;gt;gt; gt; on
gt;gt;gt; gt; the active worksheet that is stopping me changing the format? When I
gt;gt;gt; gt; look
gt;gt;gt; gt; at
gt;gt;gt; gt; the format cells, it does say that the cells are Accounting and 2
gt;gt;gt; gt; decimal
gt;gt;gt; gt; places
gt;gt;gt; gt;
gt;gt;gt; gt; In fact whatever I change it to, the cells remain the same
gt;gt;gt; gt; value/output
gt;gt;gt; gt; display.
gt;gt;gt; gt;
gt;gt;gt; gt; --
gt;gt;gt; gt; Thank you in advance.
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;
gt;
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 youquot;Niek Ottenquot; wrote:

gt; BTW, slight modification of my procedure should help:
gt;
gt; Format an empty cell as Number. Enter zero. Copy.
gt; Select your quot;numbersquot;. Editgt;Paste Special, check quot;Addquot;
gt; This *should* work!
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;Niek Ottenquot; gt; wrote in message
gt; ...
gt; gt; What happens if you do a test with ISNUMBER()?
gt; gt;
gt; gt; --
gt; gt; Kind regards,
gt; gt;
gt; gt; Niek Otten
gt; gt;
gt; gt; quot;per-ardua-ad-astraquot; gt; wrote in
gt; gt; message ...
gt; gt;gt; Niek
gt; gt;gt; Thanks for the rapid response. I initially thought that this was a
gt; gt;gt; possibility but I am convinced that the number is a number and not text.
gt; gt;gt; I
gt; gt;gt; did as you said but the value remained the same. I also copied and
gt; gt;gt; special
gt; gt;gt; pasted (add) another number from another part of the spreadsheet and it
gt; gt;gt; added
gt; gt;gt; it to the field value, but leaving the format left justified. My
gt; gt;gt; apologies
gt; gt;gt; if I am missing something glaring in my face.
gt; gt;gt; --
gt; gt;gt; Thank you in advance.
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;Niek Ottenquot; wrote:
gt; gt;gt;
gt; gt;gt;gt; Your quot;numbersquot; are actually text.
gt; gt;gt;gt; Copy an empty cell.
gt; gt;gt;gt; Select your quot;numbersquot;.
gt; gt;gt;gt; Editgt;Paste special, check Add.
gt; gt;gt;gt;
gt; gt;gt;gt; --
gt; gt;gt;gt; Kind regards,
gt; gt;gt;gt;
gt; gt;gt;gt; Niek Otten
gt; gt;gt;gt;
gt; gt;gt;gt; quot;per-ardua-ad-astraquot; gt; wrote
gt; gt;gt;gt; in
gt; gt;gt;gt; message ...
gt; gt;gt;gt; gt; My apologies if this is a known bug or I am missing something...
gt; gt;gt;gt; gt;
gt; gt;gt;gt; gt; On a worksheet in a spreadsheet, I have some cells already having
gt; gt;gt;gt; gt; numeric
gt; gt;gt;gt; gt; values in. When I try and format to Accounting Category, they remain
gt; gt;gt;gt; gt; as
gt; gt;gt;gt; gt; eg
gt; gt;gt;gt; gt; 4.4, 0.9 left justified, rather than 4.40 and 0.90 right justified.
gt; gt;gt;gt; gt;
gt; gt;gt;gt; gt; I have inserted another column to no avail. Is there some global
gt; gt;gt;gt; gt; action
gt; gt;gt;gt; gt; on
gt; gt;gt;gt; gt; the active worksheet that is stopping me changing the format? When I
gt; gt;gt;gt; gt; look
gt; gt;gt;gt; gt; at
gt; gt;gt;gt; gt; the format cells, it does say that the cells are Accounting and 2
gt; gt;gt;gt; gt; decimal
gt; gt;gt;gt; gt; places
gt; gt;gt;gt; gt;
gt; gt;gt;gt; gt; In fact whatever I change it to, the cells remain the same
gt; gt;gt;gt; gt; value/output
gt; gt;gt;gt; gt; display.
gt; gt;gt;gt; gt;
gt; gt;gt;gt; gt; --
gt; gt;gt;gt; gt; Thank you in advance.
gt; gt;gt;gt;
gt; gt;gt;gt;
gt; gt;gt;gt;
gt; gt;
gt; gt;
gt;
gt;
gt;