ExcelBanter - Number

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Number (https://www.excelbanter.com/excel-discussion-misc-queries/257344-number.html)

hungayun

Number

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?

מיכאל (מיקי) אבידן

Number

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?

All times are GMT +1. The time now is 02:18 AM.