Custom Format Keep in Number Format 100 (10x10)

muhammad susanto

Well-known Member
Joined
Jan 8, 2013
Messages
1,741
Office Version
  1. 2016
  2. 2010
Platform
  1. Windows
hi all...

how to show this data in a cell (in number format not text format)
100 (10x10)
200 (40x5)
1000 (20x50)

etc..

it' possible typing in a cell

thank in advance..

.sst
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Fazza

MrExcel MVP
Joined
May 17, 2006
Messages
9,368
apa?

please can you provide further explanation?

my initial thought, is it can't be done. but, I'm not totally clear on what is wanted. :)
 

Watch MrExcel Video

Forum statistics

Threads
1,108,911
Messages
5,525,593
Members
409,652
Latest member
strangelyangely

This Week's Hot Topics

Top