| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
number
the error is :"the number in this cell is formatted as text or preceded by an
astrophe", It means we must convert it to number and we can do, but I don't want this error appear in other excel file again.How can I do? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
number
This can be easily avoided. Before making any entries into a worksheet or
template, make sure the cells to be used for numerical input have been pre-formatted to General, not Text. -- Gary''s Student - gsnu201001 "hungayun" wrote: the error is :"the number in this cell is formatted as text or preceded by an astrophe", It means we must convert it to number and we can do, but I don't want this error appear in other excel file again.How can I do? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
| Formula to change scientific number to regular number or text | Excel Discussion (Misc queries) | |||
| Count number of times a specific number is displayed in a cell ran | Excel Worksheet Functions | |||
| Rounding a number to a multiple quantity that adds to a fixed total number | Excel Worksheet Functions | |||
Linear Mode
