Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Format as General then F2 and ENTER.
If you have a great lot of these, copy an empty cell and select the great lot of cells and Paste SpecialAddOKEsc. Gord Dibben MS Excel MVP On 5 Apr 2007 03:41:10 -0700, "guy.yeon" wrote: Hi Thanks for the advice. I had tried that too but it didn't work. Thanks, Guy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Autofilter - failure to display ALL data down a column | Excel Worksheet Functions | |||
Failure to display currency format | Excel Discussion (Misc queries) | |||
Calculation Failure | Excel Discussion (Misc queries) | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions |