Як змінити або перетворити число в текст у Excel?

Іноді ви можете не хотіти, щоб числа в клітинках брали участь у обчисленні, або ви можете хотіти відображати початкові нулі в числах у клітинках. Для цього вам може знадобитися змінити число на текст. Наступні методи можуть перетворити числа в клітинках у текст у Excel.

Перетворення числа в текст за допомогою функції Текст

Перетворити число в текст за допомогою команди Форматувати клітинки

Перетворення числа в текст за допомогою Kutools для Excel

Перетворення числа в текст за допомогою функції Текст

Якщо ви знайомі з формулами Microsoft Excel, ви можете перетворити числа в клітинках у текст за допомогою функції Текст.

Якщо ви просто хочете лише перетворити число в текст без будь-якого форматування, ви можете скористатися формулою: = ТЕКСТ (A1, "0");

1. У клітинку E1 введіть формулу = ТЕКСТ (A1, "0").

2. Потім натисніть вводити ключ. І виберіть клітинку E1, перетягніть маркер заповнення на діапазон комірок, до яких потрібно застосувати цю формулу. Дивіться знімок екрана:

примітки: Оскільки дані є формулами, ви можете змінити формули на значення. Скопіюйте клітинки та клацніть правою кнопкою миші туди, куди потрібно вставити значення, та виберіть Вставити спеціальне> Значення.

Якщо ви хочете відобразити початковий нуль у цифрах, ви можете скористатися цією формулою: = ТЕКСТ (A1, "00000"); як от перетворити 23 на 00023.

Як описано вище, якщо застосувати цю формулу, ви отримаєте такий результат:

І якщо ви хочете перетворити числа в текст, що містить кілька десяткових цифр, ви можете скористатися цією формулою: = ТЕКСТ (A1, "0.000"). Як от перетворити 23 на 23.000.

Також з наведеними вище кроками, якщо ви застосуєте цю формулу, ви отримаєте результат у вигляді наступних скріншотів:

примітки: Ви можете визначити стиль тексту. Наприклад, якщо ви хочете перетворити номери в текст у форматі телефонного номера, ви можете замінити "000" на "00-00000" або іншими.

Перетворіть або напишіть цифри в англійську або китайську валюту:

з Kutools для Excel's Числа до слів Ви можете в Excel писати цифри англійською та китайською мовами. Наприклад, можна писати "12.75"К"Дванадцять доларів сімдесят п’ять центів".

Kutools для Excel: з більш ніж 300 зручними надбудовами Excel, спробуйте безкоштовно без обмежень протягом 30 днів. Завантажте та безкоштовно пробну версію зараз!

Перетворити число в текст за допомогою команди Форматувати клітинки

Microsoft Excel Формат ячеек команда також може перетворити числа в текст.

1. Виберіть номери, які потрібно перетворити в текст.

2. Клацніть правою кнопкою миші на вибраному діапазоні та виберіть Форматувати коміркупункт з контекстного меню. Дивіться знімок екрана:

3, в Формат ячеек діалоговому вікні, виберіть текст елемент в Категорія коробка під Номер вкладку, а потім натисніть кнопку OK кнопку. Дивіться знімок екрана:

4. Потім числа у вибраному діапазоні перетворюються в текст.

Перетворення числа в текст за допомогою Kutools для Excel

Якщо у вас є Kutools для Excel встановлено, вам буде простіше перетворити числа в клітинках у текст за допомогою Перетворення тексту та числа.

Kutools для Excel : з більш ніж 300 зручними надбудовами Excel, які можна спробувати без обмежень протягом 30 днів.

Перейдіть до Завантажити
Безкоштовна пробна версія 30 днів Купити
PayPal / MyCommerce

після установки Kutools для Excel, будь ласка, виконайте наведені нижче дії:

1. Виберіть діапазон із номерами, які потрібно змінити на текст.

2. Клацання Кутулс > зміст > Перетворення тексту та числа. Дивіться знімок екрана:

3, в Перетворення тексту та числа діалогове вікно, перевірте Число до тексту , а потім клацніть на OK or Застосовувати кнопку. І всі числа перетворені в текст у вихідному діапазоні. Дивіться знімок екрана:

Натисніть, щоб завантажити Kutools для Excel та безкоштовну пробну версію зараз!

Пов'язані статті:

Як змінити або перетворити текст на число в Excel?

Найкращі інструменти для підвищення продуктивності офісу

Kutools для Excel вирішує більшість ваших проблем і збільшує продуктивність на 80%

Повторне використання: Швидко вставте складні формули, діаграми і все, що ви використовували раніше; Шифрувати комірки з паролем; Створити список розсилки та надсилати електронні листи ...
Супер формула бар (легко редагувати кілька рядків тексту та формули); Макет читання (легко читати та редагувати велику кількість комірок); Вставте у відфільтрований діапазон...
Об’єднати клітинки / рядки / стовпці без втрати даних; Вміст розділених комірок; Об'єднати повторювані рядки / стовпці... Запобігання дублюючим клітинам; Порівняйте діапазони...
Виберіть Повторюваний або Унікальний Рядки; Виберіть Пусті рядки (усі клітинки порожні); Супер знахідка та нечітка знахідка у багатьох робочих зошитах; Випадковий вибір ...
Точна копія Кілька клітинок без зміни посилання на формулу; Автоматичне створення посилань на кілька аркушів; Вставте кулі, Прапорці та інше ...
Витяг тексту, Додати текст, Видалити за позицією, Видаліть пробіл; Створення та друк проміжних підсумків підкачки; Перетворення вмісту комірок та коментарів...
Супер фільтр (зберегти та застосувати схеми фільтрів до інших аркушів); Розширене сортування за місяцем / тижнем / днем, частотою та іншим; Спеціальний фільтр жирним, курсивом ...
Поєднайте робочі зошити та робочі аркуші; Об’єднати таблиці на основі ключових стовпців; Розділіть дані на кілька аркушів; Пакетне перетворення xls, xlsx та PDF...
Понад 300 потужних функцій. Підтримує Office / Excel 2007-2019 та 365. Підтримує всі мови. Простота розгортання на вашому підприємстві чи в організації. Повна функція 30-денної безкоштовної пробної версії. 60-денна гарантія повернення грошей.

Детальніше ... Завантажити безкоштовно... Придбати ...

Вкладка Office забезпечує інтерфейс з вкладками для Office і значно спрощує вашу роботу

Увімкніть редагування та читання на вкладках у Word, Excel, PowerPoint, Publisher, Access, Visio та Project.
Відкривайте та створюйте кілька документів на нових вкладках того самого вікна, а не в нових вікнах.
Збільшує вашу продуктивність на 50% та зменшує сотні клацань миші для вас щодня!

Детальніше ... Завантажити безкоштовно... Придбати ...

109 Comments
Login

Sort by Newest
- Best
- Popular
- Newest
- Oldest

You are guest

or post as a guest, but your post won't be published automatically.

Loading comment... The comment will be refreshed after 00:00.

To post as a guest, your comment is unpublished.
Glenys Pollock · 1 years ago
how do I maintain -1 as a superscript when I make a graph from an excel spreadsheet
- Reply
To post as a guest, your comment is unpublished.
eduarlevy@gmail.com · 1 years ago
I would like to convert the date 201901 in word " january¨ or number 01 (means january in numbers) in excel sheet. Thank you
- Reply
To post as a guest, your comment is unpublished.
Alice · 2 years ago
How do you convert to text an amount with decimal number of which the decimal numbers remain as numbers? example: 750.25 - SEVEN HUNDRED FIFTY & 25/100.. Thank you
- Reply
To post as a guest, your comment is unpublished.
Anton Thelander · 2 years ago
Large thanks!
- Reply
To post as a guest, your comment is unpublished.
Tere Martin Rangel · 2 years ago
Cuando convierto un numero en texto me lo pone en Ingles y en Dólares, lo necesito es en Español y en pesos Mexicanos, ¿como puedo resolver esto?
De antemano gracias por la atención que se sirva darme.
- Reply
To post as a guest, your comment is unpublished.
mg · 2 years ago
Hi, not working in our currency which is philippine peso. Kindly help. Thank you.
- Reply
To post as a guest, your comment is unpublished.
Praveen · 3 years ago
After converting words to figures, How can start with "Rupees" and end with "Only"
- Reply
To post as a guest, your comment is unpublished.
MNB · 3 years ago
If i have assign
0 as Q
1 as W
2 as R
3 as E
4 as Z
5 as S
6 as T
7 as B
8 as K
9 as A
how to convert a numerical value to text code like 2356 i want 2 as R, 3 as E, 5 as S, 6 as T, so when i write 2356 i got result REST?
- Reply
- To post as a guest, your comment is unpublished.
  Ata · 2 years ago
  
  A workaround can be using the SUBSTITUTE formula ten times to replace all the numbers with the respective letters:
  
  =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,0,"Q"),1,"W"),2,"R"),3,"E"),4,"Z"),5,"S"),6,"T"),7,"B"),8,"K"),9,"A")
  
  Where A1 is the reference cell for the numeric values.
  
  Reply
To post as a guest, your comment is unpublished.
Ramesh · 3 years ago
When I entered Numbers in Cell Eg : 150 the will written as One hundred and fifty
- Reply
To post as a guest, your comment is unpublished.
mary · 3 years ago
how translate staff id to text as "filled" and vice versa for nil staff ID to 'vacant"
- Reply
To post as a guest, your comment is unpublished.
sikhar.1791@gmail.com · 3 years ago
i m a novice. text in cells read as 1234 5678 1234 i.e with a space bet each 4 digit clusters. how can i compress it as 123456781234 ?
- Reply
- To post as a guest, your comment is unpublished.
  Ata · 3 years ago
  
  =SUBSTITUTE(A1," ","")
  Where A1 is reference cell for 1234 5678 1234
  
  Reply
  
  To post as a guest, your comment is unpublished.
  stephdegr@gmail.com · 2 years ago
  
  Great tip thanks. Now FYI this didn't work at first for me, as for some reason it didn't recognize the space.. but when I cut and pasted the "space" from the source (cut-and-pasted financial values from a web page) instead of pressing the space bar it worked fine.
  
  Reply
  
  To post as a guest, your comment is unpublished.
  Ata · 2 years ago
  
  It might be another Character that appears like the Space character. When you copy and paste data from external sources such as websites, unwanted characters will come across with different ASCII codes that may look like the Space character.
  
  The above formula meant to remove only the Space character from your string. Space character means the value of the Char(32) on the ASCII values.
  
  Best would be to modify the formula as =SUBSTITUTE(A1,CHAR(32),"")
  
  Reply
- To post as a guest, your comment is unpublished.
  vinayujjain@gmail.com · 3 years ago
  
  Try Using =CONCATENATE("",LEFT(H20,4),MID(H20,6,4),RIGHT(H20,4))
  
  Whereis H20 is reference cell for 1234 5678 1234
  
  Reply
  
  To post as a guest, your comment is unpublished.
  Anonymous · 3 years ago
  
  Use replace function. Highlight the cells you want to edit then Ctrl+H. Replace space to blank
  
  Reply
To post as a guest, your comment is unpublished.
kamlesh manchekar · 3 years ago
I want to convert digit into words in indian language? How to do that?
- Reply
- To post as a guest, your comment is unpublished.
  rockymondal7063@gmail.com · 1 years ago
  
  Add this with below formulas in one
  
  &CHOOSE(MID(TEXT(B3,"000000000.00"),5,1)+1,,," Twenty"," Thirty"," Forty"," Fifty"," Sixty"," Seventy"," Eighty"," Ninety")
  &IF(--MID(TEXT(B3,"000000000.00"),5,1)<>1,CHOOSE(MID(TEXT(B3,"000000000.00"),6,1)+1,," One"," Two"," Three"," Four"," Five"," Six"," Seven"," Eight"," Nine"),CHOOSE(MID(TEXT(B3,"000000000.00"),6,1)+1," Ten"," Eleven"," Twelve"," Thirteen"," Fourteen"," Fifteen"," Sixteen"," Seventeen"," Eighteen"," Nineteen"))
  &IF((--MID(TEXT(B3,"000000000.00"),4,1)+MID(TEXT(B3,"000000000.00"),5,1)+MID(TEXT(B3,"000000000.00"),6,1))=0,,IF(OR((--MID(TEXT(B3,"000000000.00"),7,1)+MID(TEXT(B3,"000000000.00"),8,1)+MID(TEXT(B3,"000000000.00"),9,1))=0,--MID(TEXT(B3,"000000000.00"),7,1)<>0)," Thousand "," Thousand and "))
  &CHOOSE(MID(TEXT(B3,"000000000.00"),7,1)+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine")
  &IF(--MID(TEXT(B3,"000000000.00"),7,1)=0,,IF(AND(--MID(TEXT(B3,"000000000.00"),8,1)=0,--MID(TEXT(B3,"000000000.00"),9,1)=0)," Hundred "," Hundred and "))&
  CHOOSE(MID(TEXT(B3,"000000000.00"),8,1)+1,,,"Twenty ","Thirty ","Forty ","Fifty ","Sixty ","Seventy ","Eighty ","Ninety ")
  &IF(--MID(TEXT(B3,"000000000.00"),8,1)<>1,CHOOSE(MID(TEXT(B3,"000000000.00"),9,1)+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine"),CHOOSE(MID(TEXT(B3,"000000000.00"),9,1)+1,"Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen"))
  
  &" Euro & "&RIGHT(TEXT(B3,"000000000.00"),2)&"/100"
  
  Reply
- To post as a guest, your comment is unpublished.
  rockymondal7063@gmail.com · 1 years ago
  
  =CHOOSE(LEFT(TEXT(B3,"000000000.00"))+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine")
  &IF(--LEFT(TEXT(B3,"000000000.00"))=0,,IF(AND(--MID(TEXT(B3,"000000000.00"),2,1)=0,--MID(TEXT(B3,"000000000.00"),3,1)=0)," Hundred"," Hundred and "))
  &CHOOSE(MID(TEXT(B3,"000000000.00"),2,1)+1,,,"Twenty ","Thirty ","Forty ","Fifty ","Sixty ","Seventy ","Eighty ","Ninety ")
  &IF(--MID(TEXT(B3,"000000000.00"),2,1)<>1,CHOOSE(MID(TEXT(B3,"000000000.00"),3,1)+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine"),
  CHOOSE(MID(TEXT(B3,"000000000.00"),3,1)+1,"Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen"))
  &IF((--LEFT(TEXT(B3,"000000000.00"))+MID(TEXT(B3,"000000000.00"),2,1)+MID(TEXT(B3,"000000000.00"),3,1))=0,,IF(AND((--MID(TEXT(B3,"000000000.00"),4,1)+MID(TEXT(B3,"000000000.00"),5,1)+MID(TEXT(B3,"000000000.00"),6,1)+MID(TEXT(B3,"000000000.00"),7,1))=0,(--MID(TEXT(B3,"000000000.00"),8,1)+RIGHT(TEXT(B3,"000000000.00")))>0)," Million and "," Million "))
  &CHOOSE(MID(TEXT(B3,"000000000.00"),4,1)+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine")
  &IF(--MID(TEXT(B3,"000000000.00"),4,1)=0,,IF(AND(--MID(TEXT(B3,"000000000.00"),5,1)=0,--MID(TEXT(B3,"000000000.00"),6,1)=0)," Hundred"," Hundred and"))
  
  Reply
- To post as a guest, your comment is unpublished.
  vinayujjain@gmail.com · 3 years ago
  
  Try Using This -
  
  =IF(MID(K14,1,1)="1","One",IF(MID(K14,1,1)="2","Two",IF(MID(K14,1,1)="3","Three",IF(MID(K14,1,1)="4","Four",IF(MID(K14,1,1)="5","Five",IF(MID(K14,1,1)="6","Six",IF(MID(K14,1,1)="7","Seven",IF(MID(K14,1,1)="8","Eight",IF(MID(K14,1,1)="9","Nine",IF(MID(K14,1,1)="0","Zero",""))))))))))&" "&IF(RIGHT(K14,1)="1","One",IF(RIGHT(K14,1)="2","Two",IF(RIGHT(K14,1)="3","Three",IF(RIGHT(K14,1)="4","Four",IF(RIGHT(K14,1)="5","Five",IF(RIGHT(K14,1)="6","Six",IF(RIGHT(K14,1)="7","Seven",IF(RIGHT(K14,1)="8","Eight",IF(RIGHT(K14,1)="9","Nine",IF(RIGHT(K14,1)="0","Zero",""))))))))))
  
  Instead of Using "One" "Two" "Three", You can change what ever you want against perticular No, also above code is for only upto two digits. you can extended it to any no by adding IF with MID formula.
  
  K14 is reference cell for Number.
  
  Reply
  
  To post as a guest, your comment is unpublished.
  Darshan · 3 years ago
  
  Using this formula, 99 would convert into 'Nine Nine'. Same goes for every other number (two digited). Seems the question was to how to spell a numerical value.
  
  Reply
To post as a guest, your comment is unpublished.
amrita.d · 4 years ago
I couldn't covert number into million and billion $ currency. Help me to because I am confused.
- Reply
To post as a guest, your comment is unpublished.
Amrita · 4 years ago
I want to convert dollar currency into million or billion format . I am confused do it. could you plz guide me.
- Reply
To post as a guest, your comment is unpublished.
Shafi · 4 years ago
Some clarification, when I try to convert below number it changes its format, eg. given below can you explain why this happen? other than zero it works fine

B64=890151200020,
H64=0
J64=TEXT(B64,"000 0000 0000 0 "&H64) it changes to "089 0151 2000 2 0" instead of "890 1512 0002 0 0"
- Reply
- To post as a guest, your comment is unpublished.
  Mahmuda · 3 years ago
  
  TEXT(B64&H64,"000 0000 0000 0 0")
  
  Reply
To post as a guest, your comment is unpublished.
Excel Expert · 4 years ago
Perfect solution has been found.
Full formulas could not be written due to space limitation. mail me at mukeshbrahmankar(gmail) for the file. File would be sent on a friendly note, no commercial thing.

Regards
- Reply
- To post as a guest, your comment is unpublished.
  Avinash AVachar · 1 years ago
  
  send me excel convertor file on aavachar@gmail.com
  
  Reply
To post as a guest, your comment is unpublished.
Alexandra · 4 years ago
Any chace t change date in Text format, not keeping Date format?
Ex. 1/1/2017 d/m/yyyy in the same way but text formatting?
- Reply
- To post as a guest, your comment is unpublished.
  Excel Expert · 4 years ago
  
  Use cell formating. You can get the result as 1-Jan-2017
  
  Reply
To post as a guest, your comment is unpublished.
FALSE · 4 years ago
tnx for your solution
be healthy
- Reply
To post as a guest, your comment is unpublished.
John Smith · 4 years ago
I cannot reproduce your result. When using the TEXT formula trying to convert a number to text, the resulting content was left-aligned but there was no green triangle, meaning the content was still a number, not text. Same result when using the menu command. No triangle.

I use Excel 2010.
- Reply
To post as a guest, your comment is unpublished.
John Smith · 4 years ago
I cannot reproduce your results. When I used the first method trying to convert a number to text, the resulting number was left-aligned but there was not green triangle, meaning the content was still a number, not text. Same result with using the menu command. No green triangle.

I'm using Excel 2010.
- Reply
To post as a guest, your comment is unpublished.
Imans · 4 years ago
[quote name="Rajesh K"]Hi., Using conditional formatting you can do this. Select the range, goto conditional formatting (Cells that contain value), enter the value as per your requirement. Now select format goto Number - Custom and then type the text you are looking for within quotes. You can get your result. It will be useful for visual purpose only. Though the result displayed is in Text format, if you click on the cell it will have original value what it had. Try it....[/quote]

:lol: horray great it will save time and brain ! thanks
- Reply
To post as a guest, your comment is unpublished.
Benjamin Jackson · 4 years ago
Hi there,
i would like to convert this numner to words in excel
For example : 12,500.44 to USD twelve thousand five hundred and cents forty four only. Please give excel in add-ins format
- Reply
To post as a guest, your comment is unpublished.
CHOW · 4 years ago
Hi there,
i would like to convert this numner to words in excel
For example : 14,444.44 to FOURTEEN THOUSAND FOUR HUNDRED FORTY FOUR AND CENTS FORTY FOUR ONLY
- Reply
To post as a guest, your comment is unpublished.
Sami Awad · 4 years ago
You can easily do that, fist lets say that the number is in the cell F44, type this formula in the cell you want to display the number in text :
=SpellNumber(F44)

lets say that you have a number in cell c23 , and you wand to display it ni c 24, then you will type in c24 the following: =SpellNumber(C23)
- Reply
- To post as a guest, your comment is unpublished.
  George · 3 years ago
  
  All I get is #name when I do this
  
  Reply
To post as a guest, your comment is unpublished.
HANY · 4 years ago
I already made an excel sheet that does this, please send me your email address and i will forward it to you, i cannot find any way to attach it here for the common benefit.
- Reply
To post as a guest, your comment is unpublished.
mas · 4 years ago
how we can change a cell that contain for example [2"] ( size of pipe) to pure number 2
- Reply
To post as a guest, your comment is unpublished.
mahendran · 5 years ago
dear sir
i want typing the number in excel then next convert to words

sample-1000-One thousand
- Reply
To post as a guest, your comment is unpublished.
Mike · 5 years ago
Thank you! I needed to know how to convert numbers to zero-filled text.
- Reply
To post as a guest, your comment is unpublished.
sajid · 5 years ago
plz send me formula step wise of the convert number into text .
how can i convert a number into text
- Reply
- To post as a guest, your comment is unpublished.
  Akmal alizoy · 5 years ago
  
  =english(round(A1,2))
  
  Reply
To post as a guest, your comment is unpublished.
Balaji Panchal · 5 years ago
Dear sir
I am Balaji
I need to convert number to text like as below e.g.
- Reply
To post as a guest, your comment is unpublished.
Balaji Panchal · 5 years ago
Dear sir
I want a number to text convert for that help me sir which is function in excel
- Reply
To post as a guest, your comment is unpublished.
surjan · 6 years ago
I want to change number into words

eg: 1000 in words one thousand only
- Reply
To post as a guest, your comment is unpublished.
surjan · 6 years ago
Dear Provider,
I need to convert number to text like as below e.g.
344835.10 = THREE HUNDRED FORTY FOUR THOUSAND EIGHT HUNDRED THIRTY FIVE & TEN PAISA ONLY.
- Reply
To post as a guest, your comment is unpublished.
KALANITHI · 6 years ago
I want to change number into words

eg: 1000 in words one thousand only
- Reply
To post as a guest, your comment is unpublished.
KALANITHI · 6 years ago
Sir ,
How to change number in words in exel sheets

Example :

100 = one hundred
- Reply
To post as a guest, your comment is unpublished.
Naveen Gowda · 6 years ago
Dear Sir

I want to change number into words

eg: 1000 in words one thousand only
- Reply
To post as a guest, your comment is unpublished.
Naveen Gowda · 6 years ago
[wiki]12[/wiki][quote]12[/quote][url]1[/url]
- Reply
To post as a guest, your comment is unpublished.
Dawn · 6 years ago
WRONG. "Convert number to text with Format Cells command" does not actually change the number into text, it only changes the cell formatting. Which means it looks like text but may be treated like a number. A number changed this way will not be recognized as text by the COUNTIF function, although it will be by the COUNTA function. It's confusing even to experienced users, and Microsoft has never made the distinction clear.
- Reply
To post as a guest, your comment is unpublished.
Abu · 6 years ago
I want automatic convert into inwards in excell sheet.
- Reply
To post as a guest, your comment is unpublished.
arun prakash · 7 years ago
HOW TO CONVERT THE Numeric into Azeri words ? plz help ,Can you send the spellnumber VBA PROGRAM FOR THAT////Plz help
- Reply
To post as a guest, your comment is unpublished.
ashish Nautiyal · 7 years ago
Dear All,

Please help me about convert number to word

20= Twenty
- Reply
To post as a guest, your comment is unpublished.
Vinay Puri · 7 years ago
I Want to change number to text

example: -500 in words
- Reply
To post as a guest, your comment is unpublished.
Rajkumar · 7 years ago
sir

I want to change number into words

example: 1000 in words one thousand only
- Reply
To post as a guest, your comment is unpublished.
Ivan · 7 years ago
Use the IF Function ex: 100 One Hundred [b]=IF(I7=100,"One Hundred") [/b] Thanks,
- Reply
To post as a guest, your comment is unpublished.
connie · 7 years ago
Hello, I am needing to find out how I would convert this into a formula?

I want to input a formula in cell f5 that takes
d5 divided by e5 then multiple the answer by 100 and this would be my answer in cell f5
Example D5 is 95 and E5 is 110
95/110=0.86364x100=86.364 which if possible would like to round the 86.364 to 86 because this is the percent. 86%

Could you please help because I can not figure this formula out! Thank you ...
- Reply
- To post as a guest, your comment is unpublished.
  Ashwin Singh · 7 years ago
  
  Hi connie,
  
  please try this formula.. may be it will be helpful for you. =ROUND(D5/E5*100,0)
  
  Reply
- To post as a guest, your comment is unpublished.
  Rajesh K · 7 years ago
  
  Hi., Using conditional formatting you can do this. Select the range, goto conditional formatting (Cells that contain value), enter the value as per your requirement. Now select format goto Number - Custom and then type the text you are looking for within quotes. You can get your result. It will be useful for visual purpose only. Though the result displayed is in Text format, if you click on the cell it will have original value what it had. Try it....
  
  Reply
To post as a guest, your comment is unpublished.
Stan · 7 years ago
Does anybody know how to convert a number to a word when the value of that number reaches a specific point? Example: if a cell is higher than 10 I want that number to be replaced with a word, so my clients cant see my inventory. THANK U SO MUCH FOR UR HELP
- Reply
To post as a guest, your comment is unpublished.
AINIE · 7 years ago
#Ainie

Dear Provider,
I need to convert number to text like as below e.g.
344835.10 = THREE HUNDRED FORTY FOUR THOUSAND EIGHT HUNDRED THIRTY FIVE & TEN PAISA ONLY.

if you can help us it's better for my commercial work.[/quote]
- Reply
- To post as a guest, your comment is unpublished.
  Devrao Pawar · 7 years ago
  
  [quote name="
  
  Dear Provider,
  I need to convert number to text like as below e.g.
  344835.10 = THREE HUNDRED FORTY FOUR THOUSAND EIGHT HUNDRED THIRTY FIVE & TEN PAISA ONLY.
  
  if you can help us it's better for my commercial work.[/quote][/quote]
  
  Reply
To post as a guest, your comment is unpublished.
Md. Faruk Hossain · 7 years ago
I want convert 100 to in word One Hundred. Please tell me how way I could convert.
- Reply
To post as a guest, your comment is unpublished.
Girraj mehta · 7 years ago
Dear Provider,
I need to convert number to text like as below e.g.
1000=ONE THOUSAND ONLy
- Reply
To post as a guest, your comment is unpublished.
Loknath Sapkota · 7 years ago
Dear Provider,
I need to convert number to text like as below e.g.
344835.10 = THREE HUNDRED FORTY FOUR THOUSAND EIGHT HUNDRED THIRTY FIVE & TEN PAISA ONLY.

if you can help us it's better for my commercial work.
- Reply

Увійти в свій акаунт

Скидання пароля