ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   format cell, number category (https://www.excelbanter.com/excel-discussion-misc-queries/234235-format-cell-number-category.html)

sherbile

format cell, number category
 
I don't know why all my general number changed to currency ?

Shane Devenshire[_2_]

format cell, number category
 
Hi,

Please provide more details - you have a whole spreadsheet filled with
general formatted numbers and they suddenly change to currency? This occurs
as you type into a cell?

When you put your cursor in a blank cell and choose Format, Cells, Number
tab the active category is General? Then if you type 12 into that cell it
changes to $12.00?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"sherbile" wrote:

I don't know why all my general number changed to currency ?


sherbile

format cell, number category
 
I have a spread sheet filled with general formated numbers. Suddenly after I
open the file all the general number changed to currency, and if I click on a
blank cell the active category is currency not general.

"Shane Devenshire" wrote:

Hi,

Please provide more details - you have a whole spreadsheet filled with
general formatted numbers and they suddenly change to currency? This occurs
as you type into a cell?

When you put your cursor in a blank cell and choose Format, Cells, Number
tab the active category is General? Then if you type 12 into that cell it
changes to $12.00?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"sherbile" wrote:

I don't know why all my general number changed to currency ?



All times are GMT +1. The time now is 04:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com