Convert number

  • Thread starter Thread starter Spiros
  • Start date Start date
S

Spiros

I want to convert a number into a different format. For example the number
1205050000 (without fullstops) will be converted to 12.05.05.0000 (with 3
fullstops).
 
Hi Spiros,

Maybe Format>Cells>Number and apply a
custom format of 00"."00"."00"."0000

HTH
Martin
 
MartinW, Thank you a lot
Spirow

Ο χÏήστης "MartinW" έγγÏαψε:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Macro 5
How to convert numbers with comma decimal sepatators? 2
Transposing contents of a cell 6
Regex help 2
Macro Excel 2003 1
Images and Style sheets not found 1
Can you enter a new line in an individual cell within Excel 1
Problem restoring window - WPF 2

Back
Top