Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
currency format doesn't work first try
In excel 2003, if I type a number into a blank cell, then right click and
choose "format", if I click on "currency" and then hit "ok", it will not change the cell formatting to currency. If I do it a second time, it always works? This is clearly a bug, is there an update? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
currency format doesn't work first try
What was the cell's format before you started? Was it Text?
If so, format the cell as currency, then select the cell and hit F2 followed by enter. p6464 wrote: In excel 2003, if I type a number into a blank cell, then right click and choose "format", if I click on "currency" and then hit "ok", it will not change the cell formatting to currency. If I do it a second time, it always works? This is clearly a bug, is there an update? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
currency format doesn't work first try
It's not a known bug. I cannot reproduce it and have never seen it reported
here. Btw, a shortcut for currency format is Ctrl-Shift-4 (top row 4). -- Jim "p6464" wrote in message ... | In excel 2003, if I type a number into a blank cell, then right click and | choose "format", if I click on "currency" and then hit "ok", it will not | change the cell formatting to currency. If I do it a second time, it always | works? This is clearly a bug, is there an update? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
custom currency format for Indian rupees | Excel Discussion (Misc queries) | |||
Excel 2000 | Excel Discussion (Misc queries) | |||
when I mail merge my data (currency) format is lost? Help | Excel Discussion (Misc queries) | |||
is there a way to use the currency format in a conditional sum? | Excel Discussion (Misc queries) | |||
Changing format of column from "general" to "currency" | Excel Discussion (Misc queries) |