| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
format cell, number category
I don't know why all my general number changed to currency ?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Get cell's number format category in VBA? | Excel Discussion (Misc queries) | |||
| How do I set up a custom cell format category? | Excel Worksheet Functions | |||
| Format a column wihtout using "Format-Cells-Number-category-etc" | Excel Worksheet Functions | |||
| Help needed with cell category, ie Number/Text etc | Excel Discussion (Misc queries) | |||
| excel format cells/Number/Category: Number problem | Excel Discussion (Misc queries) | |||
Hybrid Mode
