Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi, The error is :"the number in this cell is formatted as text or proceded
by an apostrophe", in the Help of MS Excel helped but I want it not appear in other excel files again, how can I do? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
In 'Tool' 'Options...' 'Error checking' tab you can define what you are
looking for. Micky "hungayun" wrote: Hi, The error is :"the number in this cell is formatted as text or proceded by an apostrophe", in the Help of MS Excel helped but I want it not appear in other excel files again, how can I do? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I click on a telephone number in an Excel 2002 spreadsheet, and have the number dialed? | Excel Discussion (Misc queries) | |||
How to calculate number of occurencies of a specific number number | Excel Discussion (Misc queries) | |||
countif formula to find the occurances of a number that is greater than one number but less than another | Excel Discussion (Misc queries) | |||
convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
Rounding a number to a multiple quantity that adds to a fixed total number | Excel Worksheet Functions |