How to Set Character or Digits Limit in MS Excel Cells (Excel 2003-2016)

preview_player
Показать описание
Set Character Limit Error in Microsoft Excel Data

Рекомендации по теме
Комментарии
Автор

Thank you so much!!! I really need this! 😍😍😍
New Subbie here.

g.j
Автор

Kya koi aisa v formula h ki ak row m same digit or text only 3 times aaiye yadi same text ya digit 4 th time aaiye to wrong entry show reply

ranjeetkumar-hntp
Автор

Its prevents the user from entering invalid values if they enter invalid values. But its not preventing from pasting invalid values. please guide me.

sajjadsaleem
Автор

It "works" but you are considering the number as a text

MrBrunoptavares
Автор

2% fee is chargeable on market value of any property but not exceeding 25000 I have applied formula to auto calculate market value. How to apply formula to calculate 2% of market value but not exceeding 25000

shababkhan
Автор

Sir hamari aik figar 16 digit ki he. jb hum usko excel mn likhte hn to last wala digit 0 mn convert ho jata he like this 6040200547900019
Plz solve this matter

ruralhealthcentre
Автор

Sir ek video iss pe bhi banao ki jab hum koi data download krte hai to excel me already more than 18 digit rehte h to usse hum kaise sahi karein sare cells me ek sath. Like hum company ka excel download krte hai to usme serial number ka column hota serial number 18 digit ke hote hai but jab uss serial pe click krte hai to vo 000 dikhata h last me to ye bataiye ki already download data me kaise sahi karein 18 digit ke numbers vo bhi ek sath sari cells me

muskanaslamkhan