Number formatting

S

stratis

Board Regular
Joined
Dec 10, 2012
Messages
65
Hi,

I would like to type a number in excel with 10 digits, and show the following

Type
1000000000

But See
10.00.00.0000

Is this possible?

Thanks
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
Sort by date Sort by votes
Hi, you could try a custom format of:

Code: 
00\.00\.00\.0000
 
Upvote 0
You must log in or register to reply here.

Similar threads

L
  • Question
Step 1: Can you Loop Through Multiple Excel worksheets in one workbook (Copy and paste all to new worksheet or Workbook)
Replies
9
Views
394
Micron
M
N
  • Question
Format a Table Cell based on another cell value, without VBA
Replies
5
Views
71
etaf
etaf
B
  • Question
Getting a pivot table value from VBA Code
Replies
0
Views
151
BenW71
B
C
  • Question
Date formatting issue
2 3 4
Replies
34
Views
873
MARK858
MARK858
Mark F
  • Question
Three Way lookup
Replies
5
Views
194
Alex Blakenburg
A

Forum statistics

Threads
1,214,525
Messages
6,120,051
Members
448,940
Latest member
mdusw

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top